Changing the Database Provider for the FME Server Database
If you want to change the database provider for your FME Server database, you can do so by performing an “in-place” backup and restore procedure:
- Backup your FME Server configuration.
- Configure the new database server.
- Update the database connection settings in the FME common configuration file.
- Restore your FME Server configuration.
- Remove dependency, disable, and stop the previous database service.
FME Server supports PostgreSQL, SQL Server, or Oracle databases.
Backup Your FME Server Configuration
Perform a backup of your FME Server configuration:
Configure the New Database Server
Run the necessary database configuration scripts and post-configuration scripts. Follow the steps in Create the FME Server Database on a Separate Database Server.
Configure the Database Connection
Open the fmeCommonConfig.txt file, located in your <FMEServerDir>\Server\ directory.
Under the heading ‘FME SERVER SETTINGS START’, locate the section titled 'Database Connection' and update the parameters for the database you want to use for your repository.
Parameters
DB_TYPE - Identifies the database server: postgresql, sqlserver, oracle.
DB_DRIVER - The JDBC driver name used for connecting to the Repository database.
DB_JDBC_URL - The JDBC URL used for connecting to the repository database.
DB_USERNAME - The repository database user name.
DB_PASSWORD - The repository database user password.
DB_CONNECT_EXPIRY - The database connection expiry time, in seconds.
DB_SQLSTMTS_PATH - The path to the SQL statement resource bundle.
Examples
DB_TYPE=postgresql
DB_DRIVER=org.postgresql.Driver
DB_JDBC_URL=jdbc:postgresql://localhost:5432/fmeserver
DB_USERNAME=fmeserver
DB_PASSWORD=fmeserver
DB_CONNECT_EXPIRY=60
DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
DB_TYPE=sqlserver
DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
DB_JDBC_URL=jdbc:sqlserver://localhost/SQLEXPRESS
DB_USERNAME=fmeserver
DB_PASSWORD=$FMEserver
DB_CONNECT_EXPIRY=60
DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
DB_TYPE=oracle
DB_DRIVER=oracle.jdbc.driver.OracleDriver
DB_JDBC_URL=jdbc:oracle:thin:@localhost:1521:orcl
DB_USERNAME=fmeserver
DB_PASSWORD=fmeserver
DB_CONNECT_EXPIRY=60
DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
Restore Your FME Server Configuration
Perform a restore of your FME Server configuration:
- To restore from an FME Server 2014 or later configuration to FME Server 2014 or later, see Restore Configuration from FME Server 2014 and Later.
- To restore from an FME Server 2013 configuration to FME Server 2013 or later, see Restore Configuration from FME Server 2013.
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 Server (such as an express install), you must remove the dependency of the FME Server Core on that database, and then disable and stop it. For more information, see Removing the FME Server Core Dependency on the FME Server Database.