Migrating SQL Server from Other Providers
This article guides you how to migrate SQL Server database from other providers (called old instance for short) to cloud MSClusters (called cloud instance for short).
Prerequisites
Make sure the SQL Server on old instance is running with Express Edition. Otherwise, migration will probably fail. Currently, we provide SQL Server 2019/2017 Express Edition only.
We assume the database name is db_test and the user name is user_test.
1. Back up database on old instance.
We recommend making a full backup with SSMS (SQL Server Management Studio), and assuming the backup file is db_test-Full.bak.
Note: The step has to be complete on the old instance. If you do not know how to operate, please contact your old provider.
2. Upload backups to cloud platform via FTPs.
Please refer to guide on how to upload backup files.
3. Restore database on cloud instance.
3.1 Create database and user on Client Panel
Please refer to guide on how to create database db_test and user user_test on Client Panel. Do not forget to set proper permission for the user.
3.2 Restore database with SSMS
Locate backup file Right click on the database, choose Tasks > Restore > Database. And locate the uploaded backup file db_test-Full.bak.
Restore database On the Options page, check "Overwrite the existing database (WITH REPLACE)". Then, click "OK" to start the restoration.
Restore user mapping
Delete user user_test in Databases > db_test > Security.
Configure user mapping for login user_test in Security > Logins. Grant role db_owner to user on the database on the User Mapping page.
Note:
Be sure to configure user mapping for the login. Otherwise, the user will not be able to log in.
To restore a database, you must log in to SSMS with a user account that has super permissions. A normal user could not perform a restore.
Backup and restoration can also be performed via Shell command. Please refer to the steps here.