Overview of data restoration methods

Method

Related operation

Restore data to an existing RDS instance

Restore the data of an ApsaraDB RDS for SQL Server instance.

Restore data to a new RDS instance (previously known as a cloned RDS instance)

Restore data from a temporary RDS instance to the original RDS instance (This method is suitable only for RDS instances that run SQL Server 2008 R2 and use local disks.)

• Log on to a temporary RDS instance.

• Restore the data of an ApsaraDB RDS for SQL Server instance by using a temporary RDS instance.

Restore data across regions

Restore the data of an ApsaraDB RDS for SQL Server instance across regions.

Restore data to a self-managed database from backup files

Download backup files by following the instructions in Download data backup files and log backup files. Then, restore data to the self-managed database from the backup files.

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

• Use DTS to perform logical cloud migration

• Use OSS to manually migrate data to the cloud based on physical backup files

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

• Use SSMS to perform cloud migration

• 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.

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.