Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Converting Database Schema to Amazon RDS by Using the AWS Schema Conversion Tool

The AWS Schema Conversion Tool (AWS SCT) automates much of the process of converting your online transaction processing (OLTP) database schema to an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, or a PostgreSQL DB instance. The source and target database engines contain many different features and capabilities, and AWS SCT attempts to create an equivalent schema in your Amazon RDS DB instance wherever possible. If no direct conversion is possible, AWS SCT provides a list of possible actions for you to take.

You can also use AWS SCT to copy your existing on-premises database schema to an Amazon RDS DB instance running the same engine. You can use this feature to analyze potential cost savings of moving to the cloud.

AWS SCT supports the following OLTP conversions.

Source Database Target Database on Amazon RDS

Microsoft SQL Server (version 2008 and later)

Amazon Aurora (MySQL or PostgreSQL), Microsoft SQL Server, MySQL, PostgreSQL

MySQL (version 5.5 and later)

Amazon Aurora (PostgreSQL), MySQL, PostgreSQL

You can migrate schema and data from MySQL to an Amazon Aurora (MySQL) DB cluster without using AWS SCT. For more information, see Migrating Data to an Amazon Aurora DB Cluster.

Oracle (version 10.2 and later)

Amazon Aurora (MySQL or PostgreSQL), MySQL, Oracle, PostgreSQL

PostgreSQL (version 9.1 and later)

Amazon Aurora (MySQL), MySQL, PostgreSQL

If you want to convert a data warehouse schema, see Converting Data Warehouse Schema to Amazon Redshift by Using the AWS Schema Conversion Tool.

Almost all work you do with AWS SCT starts with the following three steps:

  1. Create an AWS SCT project.

  2. Connect to your source database.

  3. Connect to your target database.

If you have not created an AWS SCT project yet, see Getting Started with the AWS Schema Conversion Tool.

To convert your database schema to Amazon RDS, you take the following high-level steps: