Data source | Whether incremental data migration is supported | Supported solution | Recommended solution |
Self-managed SQL Server database | Yes | Use OSS to manually migrate data to the cloud based on physical backup files Use DBS and DTS to migrate data to the cloud based on physical backup files Use DTS to perform logical cloud migration
| Use DBS and DTS to migrate data to the cloud based on physical backup files with a few clicks. For more information, see Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance by using a physical gateway. |
Azure SQL Database | Yes | Use DTS to perform logical cloud migration Note If you want to migrate incremental data, you must set the SQL Server Incremental Synchronization Mode parameter to Polling and querying CDC instances for incremental synchronization. Use the ApsaraDB RDS console to perform end-to-end cloud migration Use SSMS to perform cloud migration
| For more information about how to use the ApsaraDB RDS console to perform end-to-end cloud migration or how to use DTS to perform logical cloud migration, see Migrate data from a SQL Server database on Microsoft Azure to ApsaraDB RDS for SQL Server. |
Azure SQL Managed Instance |
SQL Server on Azure Virtual Machines | Use DTS to perform logical cloud migration Note If you want to migrate incremental data, you must set the SQL Server Incremental Synchronization Mode parameter to Polling and querying CDC instances for incremental synchronization. Use the ApsaraDB RDS console to perform end-to-end cloud migration Use SSMS to perform cloud migration Use OSS to manually migrate data to the cloud based on physical backup files
|
Amazon RDS for SQL Server | Yes | Use DTS to perform logical cloud migration Note If you want to migrate incremental data, you must set the SQL Server Incremental Synchronization Mode parameter to Polling and querying CDC instances for incremental synchronization. Use the ApsaraDB RDS console to perform end-to-end cloud migration Use SSMS to perform cloud migration Use OSS to manually migrate data to the cloud based on physical backup files
| For more information about how to use the ApsaraDB RDS console to perform end-to-end cloud migration or how to use DTS to perform logical cloud migration, see Migrate data from an Amazon RDS for SQL Server instance to an ApsaraDB RDS for SQL Server instance. |
Huawei Cloud RDS for SQL Server | No | Use SSMS to perform cloud migration Use DTS to perform logical cloud migration for full data migration Use OSS to manually migrate full data to the cloud based on physical backup files
| For more information about how to use OSS to manually migrate full data to the cloud based on physical backup files, see Migrate the full backup data of a self-managed SQL Server instance to an ApsaraDB RDS instance that runs SQL Server 2008 R2 with cloud disks or runs SQL Server 2012 or later. |
TencentDB for SQL Server database | Yes | | For more information about how to use DTS to perform logical cloud migration, see Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance. |
No | Use SSMS to perform cloud migration |
Google Cloud SQL for SQL Server | Yes | | For more information about how to use DTS to perform logical cloud migration, see Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance. |