ApsaraDB RDS for SQL Server supports multiple migration methods for smoothly moving data between ApsaraDB RDS for SQL Server and other environments without affecting your business. Supported sources and targets include ECS-hosted, on-premises, Azure, and Amazon RDS SQL Server databases.
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