FME Flow: 2025.2

Changing the Database Provider for the FME Flow Database

Warning  

Due to dependencies in the FME Flow environment, the procedure described here is not recommended for Express installations. Instead, we recommend the following procedure to change the database provider:

  1. Back up the current configuration of FME Flow.
  2. Uninstall FME Flow and re-install a 2-tier Distributed architecture, specifying the new database provider.
  3. Restore the FME Flow Configuration.

To change the database provider for the FME Flow Database, perform an “in-place” backup and restore procedure:

  1. Disable System Encryption
  2. Backup Your FME Flow Configuration
  3. Configure the New Database Server and Connection
  4. Restart FME Flow
  5. Restore Your FME Flow Configuration
  6. Remove Dependency, Disable, and Stop the Previous Database Service
  7. Enable System Encryption

FME Flow supports PostgreSQL (recommended), SQL Server, or Oracle databases.

Note  PostgreSQL is the recommended database server with FME Flow, offering enhanced performance and stability through targeted optimizations.

Disable System Encryption

If System Encryption is Standard (this is the default setting), temporarily disable it by setting Encryption Mode to Weak before attempting to change the FME Flow Database.

Backup Your FME Flow Configuration

Perform a backup of your FME Flow configuration.

Configure the New Database Server and Connection

Run the necessary database configuration scripts and configure the connection. Follow the steps in Configure the FME Flow Database on a Separate Database Server. For additional connection scenarios and guidance, see Configuring the FME Flow Database Connection.

Restart FME Flow

Restart all of the FME Flow System Services.

Note  Upon restart, FME Flow generates a new System Encryption key. We recommend downloading this key for safekeeping.

Restore Your FME Flow Configuration

Perform a restore of your FME Flow configuration.

Remove Dependency, Disable, and Stop the Previous Database Service

If the database service from which you migrated is the PostgreSQL database that was included in a default installation of FME Flow (such as an express install), you must remove the dependency of the FME Flow Core on that database, and then disable and stop it. For more information, see Removing the FME Flow Core Dependency on the FME Flow Database.

Enable System Encryption

Enable System Encryption (recommended) by setting Encryption Mode to Standard. This will encrypt the new database and generate a new custom encryption key. Be sure to download the new key for safekeeping.