ApsaraDB RDS for SQL Server provides various data migration methods to meet different business requirements for cloud deployment or cloud migration. This helps 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 that run 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 data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance by using a physical gateway (The server on which the self-managed SQL Server database is deployed can access the Internet.)
Migrate the full backup data of a self-managed SQL Server instance to an ApsaraDB RDS instance that runs SQL Server 2008 R2 with local disks (This is a database-level data migration method.)
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 (This is a database-level data migration method.)
Migrate the incremental 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 (This is a database-level data migration method.)
Use SSMS to migrate 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.)
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
Other scenarios
Migrate data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for PostgreSQL instance
Migrate data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for MySQL V3.0 cluster
Migrate data from an ApsaraDB RDS for SQL Server instance to a PolarDB for MySQL cluster
Migrate data from an ApsaraDB RDS for SQL Server instance to a DataHub project
Migrate data from a self-managed SQL Server database to an AnalyticDB for PostgreSQL instance