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>”.

 IF EXISTS(SELECT 1 FROM [sys].[database_principals] WHERE [type] = 'S' AND name = N'QservComponent<NUMBER ID>') BEGIN	
     DROP LOGIN QservComponent<NUMBER ID>;	
 END	
 GO	
	
 IF EXISTS(Select 1 FROM [sys].[database_principals] WHERE [type] = 'S' AND name = N'QservOperator<NUMBER ID>') BEGIN	
     DROP LOGIN QservOperator<NUMBER ID>;	
 END	
 GO	
		
 CREATE LOGIN QservComponent<NUMBER ID> WITH PASSWORD ='<COMPANY PASSWORD>';	
 GO	
 CREATE LOGIN QservOperator<NUMBER ID> WITH PASSWORD ='<COMPANY PASSWORD>';	
 GO	
		
 USE <COMPANY ID>;	
 GO	
		
 IF EXISTS(SELECT 1 FROM [sys].[database_principals] WHERE name = N'QservComponent<NUMBER ID>') BEGIN	
     DROP USER QservComponent<NUMBER ID>	
 END	
 GO	
		
 IF EXISTS(select 1 from [sys].[database_principals] WHERE name = N'qservoperator<NUMBER ID>') BEGIN	
     DROP USER QservOperator<NUMBER ID>	
 END	
 GO	
		
 CREATE USER QservComponent<NUMBER ID> FOR LOGIN QservComponent<NUMBER ID>;	
 GO	
		
 CREATE USER QservOperator<NUMBER ID> FOR LOGIN QservOperator<NUMBER ID>;	
 GO	
		
 EXEC sp_addrolemember 'db_ddladmin', 'QservComponent<NUMBER ID>';	
 GO	
		
 EXEC sp_grantPermissionsAllQServ;	
 GO

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.