Amazon Database Migration Service

Migrate your databases to Amazon Web Services with minimal downtime

Amazon Database Migration Service helps you migrate databases to Amazon Web Services quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The Amazon Database Migration Service can migrate your data to and from most widely used commercial and open-source databases.

The service supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. It also allows you to stream data to Amazon Redshift, Amazon DynamoDB, and Amazon S3 from any of the supported sources, which are Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, SAP ASE, SQL Server, IBM DB2 LUW, and MongoDB, enabling consolidation and easy analysis of data in a petabyte-scale data warehouse. Amazon Database Migration Service can also be used for continuous data replication with high-availability.

The Amazon Web Services  Schema Conversion Tool makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database. Any objects that cannot be automatically converted are clearly marked so that they can be manually converted to complete the migration. SCT can also scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project. During this process, SCT performs cloud native code optimization by converting legacy Oracle and SQL Server functions to their equivalent Amazon Web Services service thus helping you modernize the applications at the same time of database migration. Once schema conversion is complete, SCT can help migrate data from a range of data warehouses to Amazon Redshift using built-in data migration agents.

Your source database can be on-premises, or in Amazon RDS or EC2 and the target database can be in either Amazon RDS or EC2. The Amazon Web Services Schema Conversion Tool supports the following conversions.

Source Database

Target Database on Amazon RDS

Oracle Database

Amazon Aurora*, MySQL, PostgreSQL, MariaDB

Oracle Data Warehouse

Amazon Redshift

Microsoft SQL Server

Amazon Aurora*, Amazon Redshift, MySQL, PostgreSQL, MariaDB


Amazon Redshift

IBM Netezza

Amazon Redshift


Amazon Redshift

HPE Vertica

Amazon Redshift

MySQL and MariaDB



Amazon Aurora*, MySQL, MariaDB

Amazon Aurora



Amazon Aurora*, MySQL, PostgreSQL


Intended Usage and Restrictions

Your use of this service is subject to the Amazon Web Services Customer Agreement.