- Home
- Data Migration Tools
- AWS Schema Conversion Tool
AWS Schema Conversion Tool
What it is
AWS Schema Conversion Tool converts database schemas between engines, including relational OLTP, data warehouse, and NoSQL schemas. When a conversion cannot be automated, it gives guidance for creating an equivalent schema in the target database. A project wizard estimates migration complexity for supported destinations and creates a report for comparing options. For warehouse migrations to Amazon Redshift, it can manage data extraction agents; it can also create, run, and monitor AWS DMS endpoints and tasks. AWS SCT converts SQL embedded in application code such as C++, C#, and Java so users can review and edit the result. Supported workload conversions include SSIS packages, Teradata workloads, and Apache Oozie workflows to specified AWS services. It integrates with AWS services for supported conversion and migration workflows, including RDS, Aurora, Redshift, S3, DynamoDB, DMS, Glue, Lambda, and Step Functions. AWS SCT is a standalone project-based application and also has a command-line tool. Planned converted schemas stay local until applied to the target. The free tool runs on 64-bit Windows, Fedora Linux, or Ubuntu Linux.
For and against
For
- Free tool for database schema conversion.
- Assesses migration complexity for supported destinations.
- Can manage Redshift extraction agents and AWS DMS tasks.
- Converts SQL embedded in application code.
- Offers both standalone and command-line tools.
Against
- Supports only 64-bit operating systems.
- Listed operating systems are Windows, Fedora, and Ubuntu.
- Continuous replication is not supported.
The verdict
AWS SCT combines schema conversion, migration assessment, and several workload conversion workflows. Its free price is useful, while the supported destinations and operating systems should be checked against a project’s needs.
Who it suits
AWS SCT may suit database teams assessing or converting schemas and workloads to supported AWS destinations. It is available for users working on 64-bit Windows, Fedora Linux, or Ubuntu Linux.
Plans and prices
AWS Schema Conversion Tool
64-bit Windows, Fedora Linux, or Ubuntu Linux
Read 30 Sep 2026 · docs.aws.amazon.com
On the record
- Application SQL
- AWS SCT can convert SQL embedded in C++, C#, Java, and other application code, which users can review, edit, and save.docs.aws.amazon.com · read 30 Sep 2026
- Assessment
- The project wizard estimates migration complexity for supported destinations and produces a report to compare target options.docs.aws.amazon.com · read 30 Sep 2026
- Command line
- AWS SCT is available both as a standalone application and as a command-line tool.docs.aws.amazon.com · read 30 Sep 2026
- Conversion guidance
- When schema conversion cannot be automated, AWS SCT provides guidance for creating equivalent schema in the target database.docs.aws.amazon.com · read 30 Sep 2026
- Data migration
- AWS SCT can manage data extraction agents for warehouse migrations to Amazon Redshift and create, run, and monitor AWS DMS endpoints and tasks.docs.aws.amazon.com · read 30 Sep 2026
- ETL and big data
- Supported conversions include SSIS packages to AWS Glue or AWS Glue Studio, Teradata workloads to Redshift RSQL or AWS Glue, and Apache Oozie to AWS Step Functions.docs.aws.amazon.com · read 30 Sep 2026
- Integrations
- AWS SCT integrates with Amazon RDS, Aurora, Redshift, S3, DynamoDB, AWS DMS, AWS Glue, AWS Lambda, and AWS Step Functions for supported conversion and migration workflows.docs.aws.amazon.com · read 30 Sep 2026
- Local operation
- AWS SCT is a standalone application with a project-based interface, and planned converted schema is stored locally until it is applied to the target.docs.aws.amazon.com · read 30 Sep 2026
- Purpose
- AWS SCT converts database schemas from one database engine to another, including relational OLTP, data warehouse, and NoSQL schemas.docs.aws.amazon.com · read 30 Sep 2026
- Security and compliance
- AWS SCT supports FIPS standards for connections to Amazon S3 or another AWS resource and is compliant with FedRAMP.docs.aws.amazon.com · read 30 Sep 2026
- Support
- AWS SCT users can submit feedback as a bug report, feature request, or general information from the tool’s Help menu.docs.aws.amazon.com · read 30 Sep 2026
- Supported operating systems
- AWS SCT is available for Microsoft Windows, Fedora Linux, and Ubuntu Linux and supports only 64-bit operating systems.docs.aws.amazon.com · read 30 Sep 2026
- Verification
- AWS provides steps to verify the downloaded compressed distribution file, including checksum and signature validation procedures.docs.aws.amazon.com · read 30 Sep 2026
