AWS Database Migration Service
User Guide (Version API Version 2016-01-01)

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

Targets for Data Migration

AWS Database Migration Service (AWS DMS) can use many of the most popular databases as a target for data replication. The target can be on an Amazon Elastic Compute Cloud (Amazon EC2) instance, an Amazon Relational Database Service (Amazon RDS) instance, or an on-premises database.

The databases include the following:

On-premises and Amazon EC2 instance databases

  • Oracle versions 10g, 11g, 12c, and 18c for the Enterprise, Standard, Standard One, and Standard Two editions.

    Note

    Support for Oracle version 18c as a target is available in AWS DMS versions 3.3.0 and later.

  • Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, 2014, and 2017. The Enterprise, Standard, Workgroup, and Developer editions are supported. The Web and Express editions aren't supported by AWS DMS.

  • MySQL versions 5.5, 5.6, and 5.7.

  • MariaDB (supported as a MySQL-compatible data target) versions 10.0.24 to 10.0.28, 10.1, 10.2 and 10.3.

    Note

    Support for MariaDB as a target is available in all AWS DMS versions where MySQL is supported.

  • PostgreSQL version 9.4 and later (for versions 9.x), 10.x, and 11.x.

    Note

    PostgreSQL versions 11.x are supported as a target only in AWS DMS versions 3.3.0 and later. You can use PostgreSQL version 9.4 and later (for versions 9.x) and 10.x as a target in any DMS version.

  • SAP Adaptive Server Enterprise (ASE) versions 15, 15.5, 15.7, 16 and later.

Amazon RDS instance databases, Amazon Redshift, Amazon S3, Amazon DynamoDB, Amazon Elasticsearch Service, Amazon Kinesis Data Streams, and Amazon DocumentDB

  • Amazon RDS for Oracle versions 11g (versions 11.2.0.3.v1 and later), 12c, and 18c for the Enterprise, Standard, Standard One, and Standard Two editions.

    Note

    Support for Oracle version 18c as a target is available in AWS DMS versions 3.3.0 and later.

  • Amazon RDS for Microsoft SQL Server versions 2008R2, 2012, 2014, and 2017. The Enterprise, Standard, Workgroup, and Developer editions are supported. The Web and Express editions aren't supported by AWS DMS.

  • Amazon RDS for MySQL versions 5.5, 5.6, and 5.7.

  • MariaDB (supported as a MySQL-compatible data target) versions 10.0.24 to 10.0.28, 10.1, 10.2 and 10.3.

    Note

    Support for MariaDB as a target is available in all AWS DMS versions where MySQL is supported.

  • PostgreSQL version 9.4 and later (for versions 9.x), 10.x, and 11.x.

    Note

    PostgreSQL versions 11.x are supported as a target only in AWS DMS versions 3.3.0 and later. You can use PostgreSQL version 9.4 and later (for versions 9.x) and 10.x as a target in any DMS version.

  • Amazon Aurora with MySQL compatibility.

  • Amazon Aurora with PostgreSQL compatibility.

  • Amazon Redshift.

  • Amazon S3.

  • Amazon DynamoDB.

  • Amazon Elasticsearch Service.

  • Amazon Kinesis Data Streams.

  • Amazon DocumentDB (with MongoDB compatibility).

Note

AWS DMS doesn't support cross-region migration for the following target endpoint types:

  • Amazon DynamoDB

  • Amazon Elasticsearch Service

  • Amazon Kinesis Data Streams