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 AWS Database Migration Service

You can use the following data stores as target endpoints for data migration using AWS Database Migration Service.

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 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) 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

    PostreSQL 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 DynamoDB, Amazon S3, Amazon Elasticsearch Service, Amazon Kinesis Data Streams, and Amazon DocumentDB

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

  • Microsoft SQL Server versions 2008R2, 2012, and 2014, 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) 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

    PostreSQL 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).