AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS 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. AWS Database Migration Service can also be used for continuous data replication with high-availability.

The AWS 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 AWS 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 AWS 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

Teradata

Amazon Redshift

IBM Netezza

Amazon Redshift

Greenplum

Amazon Redshift

HPE Vertica

Amazon Redshift

MySQL and MariaDB

PostgreSQL

PostgreSQL

Amazon Aurora*, MySQL, MariaDB

Amazon Aurora

PostgreSQL

IBM DB2 LUW

Amazon Aurora*, MySQL, PostgreSQL

 

Your use of this service is subject to the AWS Customer Agreement.