Changing Database Provider for FME Server Database
FME Server comes equipped with a PostgreSQL Database completely configured and ready for use. However, you may want to leverage a system that is already established or is required by your company policies.
If you wish to change the database for your FME Server installation, and you have already installed FME Server (for example, an "Express" installation) you can do this 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 fmeCommonConfig.txt file.
- Restart the FME Server Core service.
- Restore your FME Server configuration.
- Remove previous FME Server Database dependency, disable, and stop the previous database service.
FME Server supports PostgreSQL, Microsoft SQL Server, or Oracle databases.
| FME Lizard says... |
| Even if you plan on changing the FME Server database provider, it is recommended to install with the default PostgreSQL database. This allows you to verify that the FME Server installation is successful before making this change. |
| NEW |
| Any time the database provider was changed in older versions of FME Server it was necessary to run the post-installation scripts. In FME Server 2019.0+ this step is not required. |