Before You Begin
(1) The source CT-RDS SQL Server database version is 2012, 2014, 2016, 2017, or 2019.
(2) The CT-RDS SQL Server Web version does not support incremental data migration.
(3) The storage space of the target database must be greater than that used by the source database.
Limitations
Tables without primary keys only support full data migration, but not incremental data migration or auditing repair.
Table structure, full data, and incremental data of the source database can be migrated.
Permission Requirements of Source Server
Migration Mode | Required Permissions |
Full | SELECT |
Incremental | Sysadmin role. Enable the SQL Server proxy service |
Auditing Repair | SELECT |
For the configuration on the source database, see Configure Migration Tasks with Self-built SQL Server as Source.