Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

What Is the AWS Schema Conversion Tool?

The AWS Schema Conversion Tool helps you convert your existing database schema to a schema suitable for an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, or an Amazon RDS PostgreSQL DB instance. The AWS Schema Conversion Tool supports the following conversions.

Source DatabaseTarget Database on Amazon RDS
Microsoft SQL ServerAmazon Aurora, MySQL, PostgreSQL
MySQLPostgreSQL
OracleAmazon Aurora, MySQL, PostgreSQL
PostgreSQLAmazon Aurora, MySQL

Note

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

AWS Schema Conversion Tool Splash Screen

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 cannot be automatically converted, 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.

The following is a general outline of the steps to convert your database schema to Amazon RDS:

  1. Create your target DB instance.

  2. Create a new AWS Schema Conversion Tool project.

  3. Connect the AWS Schema Conversion Tool to your source and target.

  4. Create a database migration assessment report.

  5. Convert your schema.

  6. Apply the converted schema to Amazon RDS.

  7. Create any schema elements that couldn't be automatically converted.

For more details about each step, see Converting a Database Schema to Amazon RDS Using the AWS Schema Conversion Tool.

For an example that walks you through how to use the AWS Schema Conversion Tool, see Getting Started with the AWS Schema Conversion Tool.

AWS Schema Conversion Tool Project Window

The following is what you see in the AWS Schema Conversion Tool when you create a schema migration project.

The AWS Schema Conversion Tool Project Window
  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 automatically converted 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.

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

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