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 restricted by your company policies.
If you want to change the database provider for your FME Server database, 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 an FME Server configuration file.
- Restart FME Server.
- Restore your FME Server configuration.
- Remove dependency, disable, and stop the previous database service.
FME Server supports PostgreSQL, Microsoft SQL Server, or Oracle databases.
Mr. Flibble 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 if the FME Server installation is successful. |