Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Getting Started with the AWS Schema Conversion Tool

Following, you can find procedures that help you get started using the AWS Schema Conversion Tool (AWS SCT). AWS SCT provides a project-based user interface. Almost all work you do with AWS SCT starts with the following three steps:

  1. Create an AWS SCT project.

  2. Connect to your source database.

  3. Connect to your target database.

Before You Begin

Before you complete the procedures in this topic, you must first do the following:

Starting the AWS Schema Conversion Tool

To start the AWS Schema Conversion Tool, use the instructions for your operating system shown following.

Operating System Instructions

Fedora Linux

Run the following command:

/opt/AWSSchemaConversionTool/AWSSchemaConversionTool

Microsoft Windows

Double-click the icon for the application.

Ubuntu Linux

Run the following command:

/opt/AWSSchemaConversionTool/AWSSchemaConversionTool

Creating an AWS Schema Conversion Tool Project

The following procedure shows you how to create an AWS Schema Conversion Tool project.

To create your project

  1. Start the AWS Schema Conversion Tool.

  2. Choose New Project from the File menu. The New Project dialog box appears.

    
                        New Project dialog box
  3. Add the following preliminary project information.

    For This Parameter Do This
    Project Name

    Type a name for your project, which is stored locally on your computer.

    Location

    Type the location for your local project file.

    Choose Transactional Database (OLTP) or Data Warehouse (OLAP).
    Source DB Engine

    (OLTP) Choose Microsoft SQL Server, MySQL, Oracle, or PostgreSQL.

    (OLAP) Choose Amazon Redshift, Greenplum, Microsoft SQL Server DW, Netezza, Oracle DW, Teradata, or Vertica.

    Target DB Engine

    (OLTP) Choose Amazon Aurora (MySQL compatible), Amazon Aurora (PostgreSQL compatible), Amazon RDS for Microsoft SQL Server, Amazon RDS for MySQL, Amazon RDS for Oracle, or Amazon RDS for PostgreSQL.

    (OLAP) Choose Amazon Redshift.

  4. Choose OK to create your AWS SCT project.

Connecting to Your Source Database

The following topics show you how to connect to your source database. Choose the topic appropriate for your source database.

Connecting to Your Target Database

The following procedure shows you how to connect to your target database.

To connect to your target database

  1. Start the AWS Schema Conversion Tool.

  2. Choose Connect to target, where target indicates the database engine for your target DB instance.

  3. Add the following information to connect to your target Amazon RDS DB instance.

    For This Parameter Do This
    Server name

    Type the DNS name of your target DB instance.

    Server port

    Type the port used to connect to your target DB instance.

    User name and Password

    Type the user name and password to connect to your target DB instance.

    Note

    AWS SCT uses the password to connect to your target database only when you create your project or choose the Connect to target option in a project, where target is your target database. To guard against exposing the password for your target database, AWS SCT doesn't store the password. If you close your AWS SCT project and reopen it, you are prompted for the password to connect to your target database as needed.

    Use SSL

    Select this option if you want to use SSL to connect to your database. Provide additional information, as appropriate, on the SSL tab.

  4. Choose Test Connection to verify that you can successfully connect to your target database.

  5. Choose OK to connect to your target DB instance.

Converting Your Schema

After you get started by using the procedures in this topic, you can continue working with AWS SCT with transactional databases and data warehouses in the following topics: