
AWS Schema Conversion Tool (SCT)
AWS Schema Conversion Tool (AWS SCT) converts a source database's schema and code objects, including embedded application SQL, for targets such as Amazon RDS, Aurora and Redshift, and flags what it cannot convert. It is a downloadable application for 64-bit Windows, Fedora and Ubuntu, with a command-line version, and it needs separate JDBC drivers. Its release history opens with a preview build dated 7 October 2015.
The user guide names RDS (MySQL, MariaDB, Oracle, SQL Server, PostgreSQL), Aurora and Redshift as targets, and a converted schema can also go to a database on EC2 or be stored in S3. OLTP sources include IBM Db2 for z/OS 12, Db2 LUW, Azure SQL, SQL Server 2008 R2 through 2022, MySQL 5.5 and later, Oracle 10.1 and later, PostgreSQL 9.1 and later, and SAP ASE. Data warehouse sources are Redshift, Azure Synapse, BigQuery, Greenplum, Netezza, Oracle, Snowflake, SQL Server, Teradata and Vertica, all converted to Redshift.
Scope reaches past tables and views. SCT converts SQL embedded in C++, C#, Java and other application code, and the guide also covers ETL scripts (Informatica, SSIS and Teradata utilities) and big-data frameworks. It can create and run AWS DMS endpoints and tasks. Where a feature has no equivalent on the target, an extension-pack wizard installs AWS Lambda functions and Python libraries to emulate it. Conversion is the core job, and DMS handles the data loading.
DMS Schema Conversion
AWS now offers a second route. DMS Schema Conversion, announced on 27 November 2022, runs managed in the DMS console; AWS says it uses generative AI plus rules for commercial-to-PostgreSQL conversions and points to Amazon Q Developer for embedded application SQL in Oracle-to-PostgreSQL Java code. AWS presents the two side by side. A team needing data warehouse, ETL or application-SQL conversion should check whether the managed version covers it, because those capabilities appear in SCT's documentation.
Sources checked
The user guide lists SCT's OLTP and data warehouse sources and targets, and says it can convert SQL embedded in application code, convert ETL scripts and create AWS DMS endpoints and tasks.
docs.aws.amazon.com · Checked
SCT is a standalone application for 64-bit Windows, Fedora and Ubuntu, with a command-line version, and it needs separate JDBC drivers.
docs.aws.amazon.com · Checked
The release history starts with a preview release, build 1.0.100, dated 7 October 2015.
docs.aws.amazon.com · Checked
AWS offers two schema-conversion routes, managed DMS Schema Conversion or the downloadable SCT, and says DMS Schema Conversion uses generative AI with rules for commercial-to-PostgreSQL conversions.
aws.amazon.com · Checked
AWS announced DMS Schema Conversion on 27 November 2022 as a managed schema-conversion feature inside AWS DMS.
aws.amazon.com · Checked