AWS Schema Conversion Tool

docs.aws.amazon.com

Free plan WindowsLinuxSelf-hosted

Spec score 8.0 #7 of 32 in Cloud Migration Tools

What it is

AWS Schema Conversion Tool (AWS SCT) converts database schemas between engines, including relational OLTP, data warehouse, and NoSQL schemas. If it cannot automate a conversion, it gives guidance for creating an equivalent schema in the target database. A project wizard estimates migration complexity for supported destinations and generates a report for comparing target 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 C++, C#, Java, and other application code for users to review, edit, and save. Supported workload conversions include SSIS packages, Teradata workloads, and Apache Oozie workflows to specified AWS services. It is both a standalone, project-based application and a command-line tool. Planned converted schemas stay local until applied to the target. AWS SCT is free and supports 64-bit Microsoft Windows, Fedora Linux, and Ubuntu Linux. It also supports FIPS standards for connections to Amazon S3 or another AWS resource and is compliant with FedRAMP.

Spec sheet

Purpose: AWS SCT converts database schemas from one database engine to another, including relational OLTP, data warehouse, and NoSQL schemas.Read 30 Sep 2026 · docs.aws.amazon.com
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.Read 30 Sep 2026 · docs.aws.amazon.com
Support: AWS SCT users can submit feedback as a bug report, feature request, or general information from the tool’s Help menu.Read 30 Sep 2026 · docs.aws.amazon.com
Application SQL: AWS SCT can convert SQL embedded in C++, C#, Java, and other application code, which users can review, edit, and save.Read 30 Sep 2026 · docs.aws.amazon.com
Assessment: The project wizard estimates migration complexity for supported destinations and produces a report to compare target options.Read 30 Sep 2026 · docs.aws.amazon.com
Command line: AWS SCT is available both as a standalone application and as a command-line tool.Read 30 Sep 2026 · docs.aws.amazon.com
Conversion guidance: When schema conversion cannot be automated, AWS SCT provides guidance for creating equivalent schema in the target database.Read 30 Sep 2026 · docs.aws.amazon.com
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.Read 30 Sep 2026 · docs.aws.amazon.com
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.Read 30 Sep 2026 · docs.aws.amazon.com
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.Read 30 Sep 2026 · docs.aws.amazon.com
Security and compliance: AWS SCT supports FIPS standards for connections to Amazon S3 or another AWS resource and is compliant with FedRAMP.Read 30 Sep 2026 · docs.aws.amazon.com
Supported operating systems: AWS SCT is available for Microsoft Windows, Fedora Linux, and Ubuntu Linux and supports only 64-bit operating systems.Read 30 Sep 2026 · docs.aws.amazon.com
Verification: AWS provides steps to verify the downloaded compressed distribution file, including checksum and signature validation procedures.Read 30 Sep 2026 · docs.aws.amazon.com

Plans and prices

AWS Schema Conversion Tool Free Free tool 64-bit Windows, Fedora Linux, or Ubuntu Linux Read 30 Sep 2026 · docs.aws.amazon.com

Every AWS Schema Conversion Tool plan and price →

Strong points and limits

Strong points

Converts relational, warehouse, and NoSQL schemas
Provides migration complexity reports
Standalone and command-line options
Planned schemas remain local until applied

Limits

Only supports 64-bit Windows, Fedora, and Ubuntu
Continuous replication is not supported

Who it suits

AWS SCT suits teams assessing or converting database schemas and related workloads for supported AWS destinations. It can also help users who need to review and edit SQL embedded in application code.

Verdict

AWS SCT combines schema conversion with assessment and selected migration workflow features. Confirm that your operating system and target conversion are supported before starting a project.