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

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 8c as a target is available in AWS DMS versions 3.3.0 and later.

  • Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, 2014, and 2016, for the Enterprise, Standard, Workgroup, and Developer editions. The Web and Express editions are not supported.

  • MySQL versions 5.5, 5.6, and 5.7.

  • MariaDB (supported as a MySQL-compatible data target).

  • 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 8c as a target is available in AWS DMS versions 3.3.0 and later.

  • Amazon RDS for Microsoft SQL Server versions 2008R2, 2012, and 2014, for the Enterprise, Standard, Workgroup, and Developer editions. The Web and Express editions are not supported.

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

  • Amazon RDS for MariaDB (supported as a MySQL-compatible data target).

  • 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