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

Source DatabaseTarget Database
Microsoft SQL ServerAmazon Aurora, MySQL, PostgreSQL
MySQL

PostgreSQL

OracleAmazon Aurora, MySQL, PostgreSQL
Oracle Data WarehouseAmazon Redshift
PostgreSQLAmazon Aurora, MySQL
TeradataAmazon Redshift

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.

You can also 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.