Migrating PMP between MS SQL servers

Migrating PMP between MS SQL servers

Good morning,

I put in a support request but haven't heard back, so I figured I would post here as well in case anybody has some info:

My organization has an old instance of Password Manager Pro that's running in a cluster of VMs that we're trying to phase out and migrate to Azure. The instance is running build 9601 of PMP with an MS SQL server database as its backend. We want to move the SQL database into an Azure SQL server as well.

Based on reading other support threads in the forums, it seems that migrating the application is easy enough, just copy the entire contents of the application folder and paste into the new server. I haven't found any reliable steps for migrating the PMP database from one SQL server to a brand new one, though. Since the database is encrypted it appears I can't simply take a backup and restore on the new server.

Could someone provide steps for properly migrating the PMP database from one SQL server to another?

                New to ADSelfService Plus?