Targets for data migration - AWS Database Migration Service

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, 18c, and 19c for the Enterprise, Standard, Standard One, and Standard Two editions.

    Note

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

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

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

    Note

    Support for Microsoft SQL Server version 2019 as a target is available in AWS DMS versions 3.3.2 and later.

  • MySQL versions 5.5, 5.6, 5.7, and 8.0

    Note

    Support for MySQL 8.0 as a target is available in AWS DMS versions 3.3.1 and later.

  • 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, 11.x, and 12.x.

    Note
    • PostgreSQL versions 12.x are supported as a target in AWS DMS versions 3.3.3 and later.

    • PostgreSQL versions 11.x are supported as a target in AWS DMS versions 3.3.1 and later. You can use PostgreSQL version 9.4 and later (for versions 9.x) and 10.x as a source 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, Amazon DocumentDB, Amazon Neptune, and Apache Kafka

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

    Note

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

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

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

    Note

    Support for Microsoft SQL Server version 2019 as a target is available in AWS DMS versions 3.3.2 and later.

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

    Note

    Support for MySQL 8.0 as a target is available in AWS DMS versions 3.3.1 and later.

  • 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, 11.x, and 12.x.

    Note
    • PostgreSQL versions 12.x are supported as a target in AWS DMS versions 3.3.3 and later.

    • PostgreSQL versions 11.x are supported as a target in AWS DMS versions 3.3.1 and later. You can use PostgreSQL version 9.4 and later (for versions 9.x) and 10.x as a source 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).

  • Amazon Neptune.

  • Apache Kafka – Amazon Managed Streaming for Apache Kafka (Amazon MSK) and self-managed Apache Kafka.

Note

AWS DMS doesn't support migration across AWS Regions for the following target endpoint types:

  • Amazon DynamoDB

  • Amazon Elasticsearch Service

  • Amazon Kinesis Data Streams