TencentDB for SQL Server supports migrating data from a CVM-based self-created SQL Server database to a TencentDB for SQL Server instance. This document describes how to configure and run such a migration task.
- Before migration, please make sure that the SQL Server version of the target instance is not below that of the source instance.
- For the .bak files used for migration, please make sure that each .bak file contains only one database.
- The name of the migrated database cannot be the same as that of the TencentDB for SQL Server instance.
If the error message "Source instance info checking failed!" is displayed, please check the following items for troubleshooting:
- Whether the sa account of the source SQL Server instance exists.
- Whether the sa account password of the source SQL Server instance is correct.
- Whether the IP and port connectivity of the source SQL Server instance work properly.
Enable the sa account for the source SQL Server instance.
Select Allow remote connections to this server in Connections and set a reasonable remote query timeout period.
Select SQL Server and Windows authentication mode in Security.
Enable the built-in account and select localsystem.
Allow SQL Server port communication and open port 445 (for the basic network) or 49001 (for a VPC) in Windows Firewall.
(Optional) If VPC is selected as the CVM Network, you need to configure the freeSSHd tool.
tencent_vpc_migrate(this username cannot be changed) and the password
tencent_vpc_migrate(this password cannot be changed) as shown below:
D:\dbbackup\(this path cannot be changed) as the backup folder used during SQL Server migration. Select the SFTP tab and configure this path as the "SFTP home path".
Select the migration type, set the database (by selecting the databases/tables to be migrated), and click Save and Verify. If the verification fails, you can troubleshoot as prompted.
After the task is created, return to the task list. At this point, the task status is Initializing. Select the task and click Start to sync the task.
After the data synchronization is completed (i.e., the progress bar shows 100%), you need to click Complete to end the synchronization process. If you selected Incremental Synchronization when configuring the migration task, you need to click Complete when the progress bar shows 99%. You can check whether the migration is successful on the Status.