AWS database schema conversion options

AWS offers two schema conversion solutions to make heterogeneous database migrations predictable, fast, secure, and simple. Customers have the choice to: 1) log in to the AWS Database Migration Service (AWS DMS) console to initiate the AWS DMS Schema Conversion (DMS SC) workflow for a fully managed experience or 2) download the AWS Schema Conversion Tool (AWS SCT) software to their local drive.

Both options will automatically assess and convert 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 as action items with prescriptive instructions on how to convert, so that they can be manually converted to complete the migration.

AWS SCT can also scan your application source codes for embedded SQL statements and convert them as part of a database-schema-conversion project. During this process, AWS SCT performs cloud-native code optimization by converting legacy Oracle and SQL Server functions to their equivalent AWS service, helping to modernize the applications at the same time of database migration. Once schema conversion is complete, it can help migrate data from a range of data warehouses to Amazon Redshift using built-in data migration agents.

Key benefits of database schema conversion

Key benefits of leveraging DMS Schema Conversion and AWS SCT are:

  • Simplify database migrations by automating schema analysis, recommendations, and conversion at scale.
  • Compatible with popular databases and analytics services as source and target engines, including Oracle, SQL Server, PostgreSQL, and MySQL.
  • Save weeks or months of manual time and resources.


Supported source and target databases for AWS SCT and DMS Schema Conversion

The AWS schema conversion options support the following conversions:
  Target Database  
Source Database Schema Conversion Tool (AWS SCT) AWS DMS Schema Conversion
Oracle Database
Amazon Aurora MySQL-Compatible Edition (Aurora MySQL), Amazon Aurora PostgreSQL-Compatible Edition (Aurora PostgreSQL), MariaDB 10.5, MySQL, PostgreSQL Aurora MySQL, Aurora PostgreSQL, 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 Aurora MySQL, Aurora PostgreSQL, 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  
BigQuery Amazon Redshift  

More information on DMS Schema Conversion supported database conversions are listed here, whereas AWS SCT conversions are listed here.

Supported AWS SCT use cases

To summarize, AWS SCT can be used to:

  • Copy a database schema from a source to a target
  • Convert a database or data warehouse schema
  • Analyze a database to determine the conversion complexity
  • Analyze a database to determine any possible restrictions to running on Amazon RDS
  • Analyze a database to determine if a license downgrade is possible
  • Convert embedded SQL code in an application
  • Migrate data warehouse data to Amazon Redshift

Download and install AWS SCT on Windows and Linux

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

Visit the pricing page

Explore pricing options for AWS Database Migration Service.

Learn more 
Try DMS for free

Check out how you can use DMS for free.

Sign up 
Ready to build?

Get started with AWS Database Migration Service.

Sign in