Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

About the AWS Schema Conversion Tool User Interface

The following sections help you work with the AWS Schema Conversion Tool (AWS SCT) user interface.

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, AWS SCT 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, AWS SCT 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.

Source Schema Filter

Your source schema appears in a tree view in the left panel. If your source schema is very large, you might have a hard time locating specific objects in the tree. You can filter the objects that appear in the tree.

To filter the source schema, at the top right corner of the source schema panel, choose the filter icon as shown following.


                The filter icon for the source schema tree

When you filter the schema that appears in the tree, you don't change the objects that are converted when you convert your schema. The filter only changes what you see in the tree.

Keyboard Shortcuts for the AWS Schema Conversion Tool

The following are the keyboard shortcuts that you can use with the AWS Schema Conversion Tool (AWS SCT).

Keyboard Shortcut Description

Ctrl+N

Create a new project.

Ctrl+O

Open an existing project.

Ctrl+S

Save an open project.

Ctrl+W

Create a new project by using the wizard.

Ctrl+L

Connect to the source database.

Ctrl+R

Connect to the target database.

Related Topics