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 (MySQL or PostgreSQL), Microsoft SQL Server, MySQL, PostgreSQL

MySQL (version 5.6 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

Note

You can migrate schema and data from MySQL to an Amazon Aurora (MySQL) 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

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.

To get started with the AWS Schema Conversion Tool, 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, the AWS Schema Conversion Tool has some additional features that help you move your data and applications to the cloud:

  • You can use data migration agents to extract data from your data warehouse to prepare to migrate it to Amazon Redshift. To manage the data migration agents, you can use the AWS Schema Conversion Tool. For more information, see Using Data Migration Agents.

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

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.

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 the AWS Schema Conversion Tool.

  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.