Spotfire Server: Error "relation "sn_version" does not exist" when running migrate-db

When migrating to a different database for the Spotfire Server, you can run the migrate-db command:

https://docs.tibco.com/pub/spotfire_server/12.0.5/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/migrating_database_instance.html

Note the line "You must have created the new Spotfire database, with the same version, in the database instance to which you are migrating", this means that you need to run the create_databases.bat or create_databases.sh on the target system before running the migrate-db command.

This is due to the difference in structure in the Spotfire database between the different supported data bases.

If you run the migrate-db command before the create_databases, you can see errors like this:

Error verifying technical version and schema version of databases: ERROR: relation "sn_version" does not exist