Targets for Amazon DMS - Amazon Database Migration Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Targets for Amazon DMS

You can use different target data stores in different Amazon DMS features. The following sections contain the lists of supported target data stores for each Amazon DMS feature.

Target endpoints for data migration

You can use the following data stores as target endpoints for data migration using Amazon DMS.

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

  • Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, and 2022 for the Enterprise, Standard, Workgroup, and Developer editions

    Note

    Amazon DMS doesn't support SQL Server Web and Express editions.

  • MySQL versions 5.5, 5.6, 5.7, and 8.0

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

    Note

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

  • PostgreSQL version 9.4 and higher (for versions 9.x), 10.x, 11.x, 12.x, 13.x, 14.x, 15.x, and 16.x.

    Note

    Amazon DMS only supports PostgreSQL 15.x in versions 3.5.1 and higher. Amazon DMS only supports PostgreSQL version 16.x in versions 3.5.3 and higher.

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

  • Redis OSS versions 6.x

Amazon RDS instance databases, Amazon Redshift, Amazon Redshift Serverless, Amazon DynamoDB, Amazon S3, Amazon OpenSearch Service, Amazon ElastiCache (Redis OSS), Amazon Kinesis Data Streams, Amazon DocumentDB, Amazon Neptune, and Apache Kafka
  • Oracle versions 11g (versions 11.2.0.3.v1 and higher), 12c, 18c, and 19c for the Enterprise, Standard, Standard One, and Standard Two editions

  • Microsoft SQL Server versions 2012, 2014, 2016, 2017, 2019, and 2022 for the Enterprise, Standard, Workgroup, and Developer editions

    Note

    Amazon DMS doesn't support SQL Server Web and Express editions.

  • MySQL versions 5.5, 5.6, 5.7, and 8.0

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

    Note

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

  • PostgreSQL version 10.x, 11.x, 12.x, 13.x, 14.x, 15.x, and 16.x.

    Note

    Amazon DMS only supports PostgreSQL 15.x in versions 3.5.1 and higher. Amazon DMS only supports PostgreSQL 16.x in versions 3.5.3 and higher.

  • IBM Db2 LUW versions 11.1 and 11.5

  • Amazon Aurora MySQL-Compatible Edition

  • Amazon Aurora PostgreSQL-Compatible Edition

  • Amazon Aurora Serverless v2

  • Amazon Redshift

  • Amazon Redshift Serverless

  • Amazon S3

  • Amazon DynamoDB

  • Amazon OpenSearch Service

  • Amazon ElastiCache (Redis OSS)

  • 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

  • Babelfish (version 3.2.0 and higher) for Aurora PostgreSQL (versions 15.3/14.8 and higher)

For information about working with a specific target, see Working with Amazon DMS endpoints.

For information about supported source endpoints, see Source endpoints for data migration.

Target databases for DMS Fleet Advisor

DMS Fleet Advisor generates target recommendations using the latest version of the following target databases.

  • Amazon Aurora MySQL

  • Amazon Aurora PostgreSQL

  • Amazon RDS for MySQL

  • Amazon RDS for Oracle

  • Amazon RDS for PostgreSQL

  • Amazon RDS for SQL Server

For information about target recommendations in DMS Fleet Advisor, see Using the Amazon DMS Fleet Advisor Target Recommendations feature.

For information about supported source databases, see Source databases for DMS Fleet Advisor.

Target data providers for DMS Schema Conversion

DMS Schema Conversion supports the following data providers as targets for your migration projects.

  • Amazon Aurora MySQL 8.0.23

  • Amazon Aurora PostgreSQL 14.x, 15.x, 16.x

  • Amazon RDS for MySQL 8.0.23

  • Amazon RDS for PostgreSQL 14.x, 15.x, 16.x

  • Amazon Redshift

For information about working with a specific target, see Creating target data providers in DMS Schema Conversion.

For information about supported source databases, see Source data providers for DMS Schema Conversion.

Target data providers for DMS homogeneous data migrations

You can use the following data providers as targets for homogeneous data migrations.

  • Amazon Aurora MySQL version 5.7 and 8.0

  • Amazon Aurora PostgreSQL version 10.4 to 16.x

  • Amazon Aurora Serverless v2

  • Amazon RDS for MySQL version 5.7 and 8.0

  • Amazon RDS for MariaDB version 10.2x

  • Amazon RDS for PostgreSQL version 10.4 to 16.x

  • Amazon DocumentDB version 4.0, 5.0 and DocumentDB Elastic cluster

For information about working with a specific target, see Creating target data providers for homogeneous data migrations in Amazon DMS.

For information about supported source databases, see Source data providers for DMS homogeneous data migrations.