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:
