To move the TimeXtender Master Data Management(MDM) database between SQL Server instances, follow these instructions.
Moving the database
First, we need to move the database between servers. Here is an outline of the tasks needed:
-
Take the MDM databases offline to make sure no application is currently changing the MDM data.
-
Back up the MDM database.
-
Restore the MDM database on the new server.
-
Create an SQL Login user with db_owner privileges on the new MDM database.
Sending the connection string
The connection string to MDM needs to be updated in MDM's metadata.
- Open service such as One Time Secret
- Paste the connection string to the new SQL server with the new SQL login into the service
- Send the link to support@timextender.com
TimeXtender staff will update the metadata as soon as possible to get MDM up and running again.
Note that moving the database can affect any other applications that use the MDM data, such as PowerBI or Tableau, so be aware that after moving the database you might need to open those applications and change their connections too.
