Amazon Schema Conversion Tool - Oracle to Aurora MySQL Migration Playbook
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Schema Conversion Tool

The Amazon Schema Conversion Tool (Amazon SCT) is a Java utility that connects to source and target databases, scans the source database schema objects (tables, views, indexes, procedures, and so on), and converts them to target database objects.

This section provides a step-by-step process for using Amazon SCT to migrate an Oracle database to an Aurora MySQL database cluster. Since Amazon SCT can automatically migrate most of the database objects, it greatly reduces manual effort.

We recommend to start every migration with the process outlined in this section and then use the rest of the Playbook to further explore manual solutions for objects that couldn’t be migrated automatically. For more information, see the Amazon Schema Conversion Tool User Guide.


This walkthrough uses the Amazon Database Migration Service Sample Database. You can download it from GitHub.

Download the Software and Drivers

Download and install Amazon SCT. For more information, see Installing, verifying, and updating in the Amazon Schema Conversion Tool User Guide.

Download the Oracle and MySQL drivers. For more information, see Installing the required database drivers.

Configure Amazon SCT

  1. Start Amazon Schema Conversion Tool (Amazon SCT).

  2. Choose Settings and then choose Global settings.

  3. On the left navigation bar, choose Drivers.

  4. Enter the paths for the Oracle and MySQL drivers downloaded in the first step.

    Enter the paths for the Oracle and MySQL drivers

  5. Choose Apply and then OK.

Create a New Migration Project

  1. In Amazon SCT, choose File, and then choose New project wizard. Alternatively, use the keyboard shortcut Ctrl+W.

  2. Enter a project name and select a location for the project files. For Source engine, choose Oracle, and then choose Next.

  3. Enter connection details for the source Oracle database and choose Test connection to verify. Choose Next.

  4. Select the schema or database to migrate and choose Next.

  5. The progress bar displays the objects that Amazon SCT analyzes. When Amazon SCT completes the analysis, the application displays the database migration assessment report. Read the Executive summary and other sections. Note that the information on the screen is only partial. To read the full report, including details of the individual issues, choose Save to PDF at the top right and open the PDF document.

    Assessment report

  6. Scroll down to the Database objects with conversion actions for Amazon Aurora (MySQL compatible) section.

    Assessment report conversion statistics

  7. Scroll further down to the Detailed recommendations for Amazon Aurora (MySQL compatible) migrations section and review the migration recommendations.

  8. Return to Amazon SCT and choose Next. Enter the connection details for the target Aurora MySQL database and choose Finish.

  9. When the connection is complete, Amazon SCT displays the main window. In this interface, you can explore the individual issues and recommendations discovered by Amazon SCT.

  10. Choose the schema, open the context (right-click) menu, and then choose Create report to create a report tailored for the target database type. You can view this report in Amazon SCT.

  11. The progress bar updates while the report is generated.

  12. Amazon SCT displays the executive summary page of the database migration assessment report.

  13. Choose Action items. In this window, you can investigate each issue in detail and view the suggested course of action. For each issue, drill down to view all instances of that issue.

  14. Choose the database name, open the context (right-click) menu, and choose Convert schema. Make sure that you uncheck the sys and information_schema system schemas. This step doesn’t make any changes to the target database.

  15. On the right pane, Amazon SCT displays the new virtual schema as if it exists in the target database. Drilling down into individual objects displays the actual syntax generated by Amazon SCT to migrate the objects.

  16. Choose the database on the right pane, open the context (right-click) menu, and choose either Apply to database to automatically run the conversion script against the target database, or choose Save as SQL to save to an SQL file.

  17. We recommend saving to an SQL file because you can verify and QA the converted code. Also, you can make the adjustments needed for objects that couldn’t be automatically converted.

For more information, see the Amazon Schema Conversion Tool User Guide.