AWS Schema Conversion Tool
User Guide (Version 1.0)

Getting Started with the AWS Schema Conversion Tool

You can use the AWS Schema Conversion Tool (AWS SCT) to convert your source database schema to a schema for databases hosted on Amazon Web Services (AWS). The AWS SCT application provides a project-based user interface. Almost all work you do with AWS SCT starts with the following steps:

  1. Install AWS SCT. For more information, see Installing, Verifying, and Updating the AWS Schema Conversion Tool.

  2. Install an AWS SCT agent, if needed. AWS SCT agents are only required for certain migration scenarios, such as between heterogeneous sources and targets.For more information, see Using Data Extraction Agents.

  3. Familiarize yourself with the user interface of AWS SCT. For more information, see Using the AWS Schema Conversion Tool User Interface.

  4. Create an AWS SCT project. Connect to your source and target databases. For more information about connecting to your source database, see Source Databases for the AWS Schema Conversion Tool.

  5. Run and then review the Database Migration Assessment Report. For more information about the assessment report, see Creating and Reviewing the Database Migration Assessment Report.

  6. Convert the source database schemas. There are several aspects of the conversion you need to keep in mind, such as what to do with items that don't convert, and how to map items that should be converted a particular way. For more information about converting a source schema, see Converting Database Schemas Using the AWS Schema Conversion Tool.

    If you are converting a data warehouse schema, there are also aspects you need to consider before doing the conversion. For more information, see Converting Data Warehouse Schemas to Amazon Redshift Using the AWS Schema Conversion Tool.

  7. Applying the schema conversion to your target. For more information about applying a source schema conversion, see Using the AWS Schema Conversion Tool User Interface.

  8. The AWS SCT can also be used to convert SQL stored procedures and other application code. For more information, see Converting Application SQL Using the AWS Schema Conversion Tool

You can also use AWS SCT to migrate your data from a source database to an Amazon-managed database.