(1) The source self-built SQL Server database version is 2008 R2, 2012, 2014, 2016, 2017, or 2019.
(2) If the self-built SQL Server version is 2005 or the source RDS SQL Server version is 2008 or 2008R2, incremental data migration is not supported.
(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.
The srvname field in the sys.sysservers view is the same as the value returned by the SERVERPROPERTY function.
If the source database is the enterprise edition, 2008 or later versions must be used for incremental data migration.
If the source database is the standard edition, 2016SP1 or later versions must be used for incremental data migration.
If the source database is SQL Server 2017 (including Standard and Enterprise editions), you are advised to upgrade the version for incremental data migration.
TEXT, CURSOR, ROWVERSION, SQL_VARIANT, HIERACHYID, and GEOMETRY cannot be migrated.
If the log volume in a single database among source databases exceeds 20 MB/s, and there are more than 1000 tables for which Change Data Capture (CDC) must be enabled, heap tables, tables without primary keys, compressed tables, and calculation lists, the migration may fail.
Permission Requirements of Source Server
Migration Mode | Required Permissions |
Full | SELECT |
Incremental | Sysadmin role. Enable the SQL Server proxy service |
Auditing Repair | SELECT |
Configuration on Source Server
Data source type: Set this parameter to SQL Server. SQL Server databases within the version range can be migrated.
Server IP: Specifies the IP address of the source database to be migrated.
Port number: Specifies the port of the source database to be migrated.
User name: Specifies a user name used to connect to the source database to be migrated.
Password: Specifies the password of the user used to connect to the source database to be migrated.
Database: Specifies the name of the source database to be migrated.
Schema: Specifies the schema name used by the source server from which data is migrated.