A request to add some sort of schema version identification tag to the FME Server System Database. ex. a new metadata table.

This would serve as a way to confirm the schema version and if it matches the FME Server Core connecting to it.

Currently there is no way to determine the schema version. This can be troublesome when working in distributed environments where one needs to ensure the correct sql scripts were used to create the FME Server System Database. An example where this might manifest is during a restore where a new Core could try to insert a record that has a new attribute, however, fails because the table doesn't have the new column. It can take time to sort out the issue and learn that it is caused by an older schema being created.

Often, we are not aware that a different database script must be run for new versions of FME Server.

Other benefits

• Could be exposed via the Rest API. Then exposed in the Web UI.
• Allow System Admins to confirm quickly via Database Admin tools the version
• The core could check the version and produce warnings/errors in the log and Web UI when an Admin user logs in.

Distributed installs of FME Server continue to grow and this could help system admins and support staff in the long run.