AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

Step 5: Use the AWS Schema Conversion Tool (AWS SCT) to Convert the Oracle Schema to Aurora MySQL

Before you migrate data to Aurora MySQL, you convert the Oracle schema to an Aurora MySQL schema as described following.

To convert an Oracle schema to an Aurora MySQL schema using AWS Schema Conversion Tool (AWS SCT)

  1. Launch the AWS Schema Conversion Tool (AWS SCT). In the AWS SCT, choose File, then choose New Project. Create a new project called DMSDemoProject. Enter the following information in the New Project window and then choose OK.

    For This Parameter Do This

    Project Name

    Type DMSDemoProject.

    Location

    Use the default Projects folder and the default Transactional Database (OLTP) option.

    Source Database Engine

    Choose Oracle.

    Target Database Engine

    Choose Amazon Aurora (MySQL Compatible).

    
                             Creating a new project in the AWS Schema Conversion
                                Tool
  2. Choose Connect to Oracle. In the Connect to Oracle dialog box, enter the following information, and then choose Test Connection.

    For This Parameter Do This

    Type

    Choose SID.

    Server name

    Use the OracleJDBCConnectionString value you used to connect to the Oracle DB instance, but remove the JDBC prefix information. For example, a sample connection string you use with SQL Workbench/J might be "jdbc:oracle:thin:@do1xa4grferti8y.cqiw4tcs0mg7.us-west-2.rds.amazonaws.com:1521:ORCL". For the AWS SCT Server name, you remove "jdbc:oracle:thin:@//" and ":1521" to use just the server name: "do1xa4grferti8y.cqiw4tcs0mg7.us-west-2.rds.amazonaws.com"

    Server port

    Type 1521.

    Oracle SID

    Type ORCL.

    User name

    Type oraadmin.

    Password

    Provide the password for the admin user that you assigned when creating the Oracle DB instance using the AWS CloudFormation template.

    
                             Creating a new project in the AWS Schema Conversion
                                Tool
  3. Choose OK to close the alert box, then choose OK to close the dialog box and to start the connection to the Oracle DB instance. The database structure of the Oracle DB instance is shown. Select only the HR schema.

    
                             Testing a connection
  4. Choose Connect to Amazon Aurora. In the Connect to Amazon Aurora dialog box, enter the following information and then choose Test Connection.

    For This Parameter Do This

    Type

    Choose SID.

    Server name

    Use the AuroraJDBCConnectionString value you used to connect to the Aurora MySQL DB instance, but remove the JDBC prefix information and the port suffix. For example, a sample connection string you use with SQL Workbench/J might be "jdbc:mysql://dmsdemo-auroracluster-1u1ogdfg35v.cluster-cqiw4tcs0mg7.us-west-2.rds.amazonaws.com:3306". For the AWS SCT Server name, you remove "jdbc:mysql://" and ":3306" to use just the server name: "dmsdemo-auroracluster-1u1ogdfg35v.cluster-cqiw4tcs0mg7.us-west-2.rds.amazonaws.com"

    Server port

    Type 3306.

    User name

    Type auradmin.

    Password

    Provide the password for the admin user that you assigned when creating the Oracle DB instance using the AWS CloudFormation template.

    
                             Creating a new project in the AWS Schema Conversion
                                Tool

    AWS SCT analyses the HR schema and creates a database migration assessment report for the conversion to Amazon Aurora MySQL.

  5. Choose OK to close the alert box, then choose OK to close the dialog box to start the connection to the Amazon Aurora MySQL DB instance.

  6. Right-click the HR schema and select Create Report.

    
                             Database migration report in AWS SCT
  7. Check the report and the action items it suggests. The report discusses the type of objects that can be converted by using AWS SCT, along with potential migration issues and actions to resolve these issues. For this walkthrough, you should see something like the following:

    
                             Database migration report in AWS SCT

    You can optionally save the report as .csv or .pdf format for later analysis.

  8. Choose the Action Items tab, and review any recommendations that you see.

  9. Right-click the HR schema, and then choose Convert schema.

    
                            Choosing Convert schema in AWS SCT
  10. Choose Yes for the confirmation message. AWS SCT then converts your schema to the target database format.

    
                             AWS SCT schema conversion
  11. Choose the HR schema, and then choose Apply to database to apply the schema scripts to the target Aurora MySQL instance, as shown following.

    
                             Applying AWS SCT schema scripts
  12. Choose the HR schema, and then choose Refresh from Database to refresh from the target database, as shown following.

    
                             Refreshing from the target database

The database schema has now been converted and imported from source to target.