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 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.

The AWS Schema Conversion Tool supports the following OLTP conversions.

Source DatabaseTarget Database on Amazon RDS

Microsoft SQL Server (version 2008 and later)

Amazon Aurora, Microsoft SQL Server, MySQL, PostgreSQL

MySQL (version 5.6 and later)

MySQL, PostgreSQL

Oracle (version 10.2 and later)

Amazon Aurora, MySQL, Oracle, PostgreSQL

PostgreSQL (version 9.1 and later)

Amazon Aurora, MySQL, PostgreSQL

Note

You can migrate schema and data from MySQL to an Amazon Aurora DB cluster without using the AWS Schema Conversion Tool. For more information, see Migrating Data to an Amazon Aurora DB Cluster.

The AWS Schema Conversion Tool supports the following data warehouse conversions.

Source DatabaseTarget Database on Amazon Redshift

Greenplum Database (version 4.3 and later)

Amazon Redshift

Netezza (version 7.2 and later)

Amazon Redshift

Oracle (version 11 and later)

Amazon Redshift

Teradata (version 15 and later)

Amazon Redshift

In addition to converting your existing database schema from one database engine to another, the AWS Schema Conversion Tool has some additional features that help you move your data and applications to the cloud. The following are additional features of the AWS Schema Conversion Tool:

  • You can use the AWS Schema Conversion Tool to optimize your existing Amazon Redshift database. The AWS Schema Conversion Tool recommends sort keys and distribution keys to optimize your database. For more information, see Optimizing Amazon Redshift by using the AWS Schema Conversion Tool.

  • You can use the AWS Schema Conversion Tool 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.

  • You can use the AWS Schema Conversion Tool to convert SQL in your C++, C#, Java, or other application code. You can view, analyze, edit, and save the converted SQL code. For more information, see Converting Application SQL by Using the AWS Schema Conversion Tool.

Converting Your Schema

The AWS Schema Conversion Tool 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, the AWS Schema Conversion Tool provides guidance on how you can create equivalent schema in your target Amazon RDS database.

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

For an example that walks you through how to use the AWS Schema Conversion Tool to convert a transactional database schema, see Getting Started Converting Database Schema with the AWS Schema Conversion Tool.

For an example that walks you through how to use the AWS Schema Conversion Tool to convert a transactional database schema, see Getting Started Converting Data Warehouse Schema with the AWS Schema Conversion Tool.

The Project Window

The illustration following is what you see in the AWS Schema Conversion Tool when you create a schema migration project, and then convert a schema.

  1. In the left panel, the schema from your source database is presented in a tree view. Your database schema is "lazy loaded." In other words, when you select an item from the tree view, the AWS Schema Conversion Tool gets and displays the current schema from your source database.

     

  2. In the top middle panel, action items appear for schema elements from the source database engine that couldn't be converted automatically to the target database engine.

     

  3. In the right panel, the schema from your target DB instance is presented in a tree view. Your database schema is "lazy loaded." That is, at the point when you select an item from the tree view, the AWS Schema Conversion Tool gets and displays the current schema from your target database.

The AWS Schema Conversion Tool Project Window
  1. In the lower left panel, when you choose a schema element, properties describing the source schema element and the SQL command to create that element in the source database are displayed.

     

  2. In the lower right panel, when you choose a schema element, properties describing the target schema element and the SQL command to create that element in the target database are displayed. You can edit this SQL command and save the updated command with your project.