AWS Schema Conversion Tool (AWS SCT)

Many businesses must transition to more efficient and modern database systems as data volumes grow and performance demands increase. This could involve upgrading from an older database system to a more advanced one, switching from on-premises infrastructure to cloud-based solutions, or adopting open-source platforms to avoid being locked into a single vendor.

Manually migrating a database presents significant challenges:

• Complexity: The process involves converting intricate database objects like tables, indexes, views, and stored procedures to a format compatible with the new system.

• Error-prone: Manual conversion increases the risk of errors, especially in large and complex schemas.

• Time-consuming: The manual process can be slow and labor-intensive, delaying the overall migration.

Schema conversion tools are designed to address these challenges by automating the migration of database schemas from one system (source) to another (target). They simplify the conversion of database objects and code, ensuring they are compatible with the target system.

What is AWS SCT?

AWS Schema Conversion Tool (AWS SCT) is a standalone application that automates the conversion of database schemas from one database engine to another. AWS SCT is available for Microsoft Windows, Fedora Linux, and Ubuntu Linux. AWS SCT supports a wide range of source and target database engines, including:

• Source databases: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and more. The source database can be a self-managed engine running on-premises or on an Amazon EC2 instance.

• Target databases: Amazon RDS, Amazon Aurora, Amazon Redshift, and other cloud-native database systems.