The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations predictable. It automatically converts 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, 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.

The AWS Schema Conversion Tool supports the following conversions -

Source Database Target Database on Amazon RDS
Oracle Database
Amazon Aurora MySQL-Compatible Edition (Aurora MySQL), Amazon Aurora PostgreSQL-Compatible Edition (Aurora PostgreSQL), MariaDB 10.5, MySQL, PostgreSQL
Oracle Data Warehouse Amazon Redshift
Microsoft Azure SQL Database Aurora MySQL, Aurora PostgreSQL, MySQL, PostgreSQL
Microsoft SQL Server Amazon Redshift, Aurora MySQL, Aurora PostgreSQL, Babelfish for Aurora PostgreSQL (only for assessment reports), MariaDB, Microsoft SQL Server, MySQL, PostgreSQL
Teradata Amazon Redshift
IBM Netezza Amazon Redshift
Greenplum Amazon Redshift
HPE Vertica Amazon Redshift
MySQL Aurora PostgreSQL, MySQL, PostgreSQL
PostgreSQL Aurora MySQL, Aurora PostgreSQL, MySQL, PostgreSQL
IBM DB2 LUW Aurora MySQL, Aurora PostgreSQL, MariaDB, MySQL, PostgreSQL
IBM Db2 for z/OS Aurora MySQL, Aurora PostgreSQL, MySQL, PostgreSQL
Apache Cassandra Amazon DynamoDB
SAP ASE Aurora MySQL, Aurora PostgreSQL, MariaDB, MySQL, PostgreSQL
Amazon Redshift Amazon Redshift
Azure Synapse Analytics Amazon Redshift
Snowflake Amazon Redshift

You can download AWS Schema Conversion Tool for your platform of choice from the links below:

Standard Product Icons (Features) Squid Ink
Visit the pricing page

Explore pricing options for AWS Database Migration Service.

Learn more 
Sign up for a free account
Try DMS for free

Check out how you can use DMS for free.

Sign up 
Standard Product Icons (Start Building) Squid Ink
Ready to build?

Get started with AWS Database Migration Service.

Sign in