Skip Navigation LinksHome : Support : Database Migration

Database Migration

Switching between platforms (in-house server to an Azure cloud server or Azure cloud server to in-house server) requires migration of the existing database to the new platform. Microsoft provides two tools that can be used to migrate a database.

The Data Migration Assistant (DMA) can be downloaded for free from Microsoft here. The DMA can be used to migrate from an in-house server to the Azure platform, but does not support migration from Azure to an in-house server. 

The Sql Server Management Studio (SSMS) can be downloaded for free from Microsoft here. The SSMS is not as easy to use but supports migration from in-house to Azure and Azure to in-house. Instructions for using SSMS are available here.

To perform the database migration you must be able to log into the destination server with full administrator privileges.

Once the database has been migrated to the new server you will need to execute the script shown below to create the logins and users and provide permissions for the users. Edit the script as follows:

1.       Substitute the Company Account Id contained in the email that you received when your company account was created for “<Account ID>”.

2.       Substitute the Company Account Password contained in the email that you received when you company account was created for “<Account Password>”.

3.       Substitute the five trailing digits of your Company Account Id for “<Number ID>”.

 

IMPORTANT: YOU MUST UPDATE THE SERVER NAME ON THE MODIFY COMPANY ACCOUNT page. If the correct server name is not entered users will not be able to access the new database.

 

Copyright © 2001–2021 Focus Systems Corporation (Unknown 0.0)