Migration from PostgreSQL to MSSQL Error
I am attempting to migrate our Desktop Central Version 8 database from the default PostgreSQL database over to a MSSQL database on the same server but am receiving an error when attempting to do so.
When running changeDBServer.bat, with the migrate data option selected, the PostgreSQL database successfully backs up but fails when attempting to restore the database to the MSSQL database.
The user for the MSSQL database is configured to use SQL authentication and has been granted full access to the database server in order to negate the permissions as a potential issue.