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

Note

Regardless of the source storage engine (MyISAM, MEMORY, etc.), AWS DMS creates the MySQL-compatible target table as an InnoDB table by default. If you need to have a table that uses a storage engine other than InnoDB, you can manually create the table on the MySQL-compatible target and migrate the table using the "Do Nothing" mode. For more information about the "Do Nothing" mode, see Full Load Task Settings.

The databases include the following:

On-premises and EC2 instance databases

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

  • 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 versions 9.3 and later

  • SAP Adaptive Server Enterprise (ASE) 15.7 and later

Amazon RDS instance databases, Amazon Redshift, Amazon S3, and Amazon DynamoDB

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

  • Amazon RDS 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 MySQL versions 5.5, 5.6, and 5.7

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

  • Amazon RDS PostgreSQL versions 9.3 and later

  • Amazon Aurora with MySQL compatibility

  • Amazon Redshift

  • Amazon S3

  • Amazon DynamoDB