Updated on 2024-07-11 GMT+08:00

Backup Migration

DRS supports backup migrations of various database types.

Supported Database Types

Table 1 Database types

Data Flow

Backup File Source

Destination DB Type

Microsoft SQL Server -> RDS for SQL Server

  • On-premises Microsoft SQL Server backup files
  • RDS for SQL Server full backup files
  • Microsoft SQL Server backup files on other clouds

RDS for SQL Server DB instances

Migration Methods

Table 2 Migration methods

Data Flow

Full Migration

Incremental Migration

Microsoft SQL Server -> RDS for SQL Server

Supported

Supported

Supported Database Versions

Table 3 Database versions

Data Flow

Backup File Version

Destination DB Version

Microsoft SQL Server -> RDS for SQL Server

On-premises and other cloud's Microsoft SQL Server backup file versions:

  • Microsoft SQL Server 2000 Enterprise Edition and Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition and Standard Edition
  • Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition

RDS for SQL Server full backup file versions:

  • Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition
  • Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition

Backup Migration Scenarios

Table 4 Migration scenarios

Scenario

Description

OBS bucket

If you copy the database backup files to an Object Storage Service (OBS) bucket, ensure that the OBS bucket is located in the same region as the destination instance.

RDS full backup

If you select an RDS full backup as the backup file source, ensure that the RDS instance has a full backup.