Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

What Is the AWS Schema Conversion Tool?

You can use the AWS Schema Conversion Tool (AWS SCT) to convert your existing database schema from one database engine to another. You can convert relational OLTP schema, or data warehouse schema. Your converted schema is suitable for an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, an Amazon RDS PostgreSQL DB instance, or an Amazon Redshift cluster.

Note

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.

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

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

AWS SCT supports the following data warehouse conversions.

Source Database Target Database on Amazon Redshift

Greenplum Database (version 4.3 and later)

Amazon Redshift

Microsoft SQL Server (version 2008 and later)

Amazon Redshift

Netezza (version 7.0.3 and later)

Amazon Redshift

Oracle (version 10 and later)

Amazon Redshift

Teradata (version 13 and later)

Amazon Redshift

Vertica (version 7.2.2 and later)

Amazon Redshift

Converting Your Schema

AWS SCT provides a project-based user interface to automatically convert the database schema of your source database into a format compatible with your target Amazon RDS instance. If schema from your source database can't be converted automatically, AWS SCT provides guidance on how you can create equivalent schema in your target Amazon RDS database.

For information about how to install AWS SCT, see Installing and Updating the AWS Schema Conversion Tool.

To get started with AWS SCT, and create your first project, see Getting Started with the AWS Schema Conversion Tool.

To start converting your schema, see Converting Database Schema to Amazon RDS by Using the AWS Schema Conversion Tool or Converting Data Warehouse Schema to Amazon Redshift by Using the AWS Schema Conversion Tool.

Additional Features of the AWS Schema Conversion Tool

In addition to converting your existing database schema from one database engine to another, AWS SCT has some additional features that help you move your data and applications to the cloud:

  • You can use data extraction agents to extract data from your data warehouse to prepare to migrate it to Amazon Redshift. To manage the data extraction agents, you can use AWS SCT. For more information, see Using Data Extraction Agents.

  • You can 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 and of changing your license type.

Providing Customer Feedback

You can provide feedback about the AWS Schema Conversion Tool. You can file a bug report, you can submit a feature request, or you can provide general information.

To provide feedback about AWS SCT.

  1. Start the AWS Schema Conversion Tool.

  2. Open the Help menu and then choose Leave Feedback. The Leave Feedback dialog box appears.

  3. For Area, choose Information, Bug report, or Feature request.

  4. For Source database, choose your source database. Choose Any if your feedback is not specific to a particular database.

  5. For Target database, choose your target database. Choose Any if your feedback is not specific to a particular database.

  6. For Title, type a title for your feedback.

  7. For Message, type your feedback.

  8. Choose Send to submit your feedback.

Related Topics