ApsaraDB RDS for SQL Server provides various data migration methods to meet different business requirements for cloud deployment or cloud migration. These methods help you smoothly migrate data between SQL Server databases deployed in different environments and ApsaraDB RDS for SQL Server instances without affecting your business. The SQL Server databases deployed in different environments include self-managed SQL Server databases running on Elastic Compute Service (ECS) instances, on-premises self-managed SQL Server databases, SQL Server databases on Microsoft Azure, and databases on Amazon RDS for SQL Server instances.
Scenario 1: Migrate data between ApsaraDB RDS instances
Scenario 2: Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance
Migrate full backup data to the cloud (This is a database-level data migration method.)
Migrate incremental backup data to the cloud (This is a database-level data migration method.)
Migrate data from a self-managed SQL Server instance to an ApsaraDB RDS for SQL Server instance (This is an instance-level data migration method.)
Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance (Uses JDBC logical protocol to obtain SQL statements and write them to the destination)
Migrate data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance by using a physical gateway (Uses native database physical backup protocol to write data blocks to the destination)
Use SSMS to migrate data to an ApsaraDB RDS for SQL Server instance
Use the data import feature of DMS to import data in batch (Only data in the SQL, CSV, and Excel format is supported.)
Scenario 3: Migrate data from an SQL Server database on a third-party cloud to an ApsaraDB RDS for SQL Server instance
Scenario 4: Migrate data from an SQL Server database on other Alibaba Cloud services to an ApsaraDB RDS for SQL Server instance
Scenario 5: Migrate data from an ApsaraDB RDS for SQL Server instance to an on-premises SQL Server database
Migrate the data of an ApsaraDB RDS for SQL Server instance to a self-managed SQL Server instance