Part 3 - Using AWS Schema Conversion Tool

1. Launch AWS Schema Conversion Tool (SCT) on the EC2 instance.

2. Go to File > New Project Wizard

3. Enter the following values into the form and then click “Next

Setting Value
Project Name AWS Schema Conversion Tool Project1
Location C:\Users\Administrator\AWS Schema Conversion Tool\Projects
Database Type Transactional Database (OLTP)
Source Database Engine Microsoft SQL Server / I want to switch engine and optimize for the cloud

4. Enter the following values into the form and then click “Test Connection” (In the lower left of the dialog box) Once the connection is tested successfully, click “Next

Setting Value
Server Name
Server Port 1433
Instance Name
User Name awssct
Password Password1
Use SSL Unchecked
Microsoft SQL Server Driver Path D:\JDBC Drivers\sqljdbc_6.0\enu\jre8\sqljdbc42.jar

Note: You can also get the EC2 hostname by pasting the following metadata URI in Internet Explorer on your EC2 instance: http://169.254.169.254/latest/meta-data/hostname

5. Select the ‘SalesDB’ database and click Next

6. Review the Database Migration Assessment Report and then click “Next

7. Enter the following values into the form and then click “Test Connection” Once the connection is tested successfully, click “Finish

Setting Value
Target Database Engine Amazon Aurora (MySQL Compatible)
Server Name
Server Port 3306
User Name admin
Password
Use SSL Unchecked
Amazon Aurora Driver Path D:\JDBC Drivers\mysql-connector-java-8.0.12\mysql-connector-java-8.0.12\mysql-connector-java-8.0.12.jar

8. Right Click on the database ‘SalesDB’ and click ‘Create Report’.

9. Read the Assessment results and Close the SCT wizard.

Note: We are not going to convert the schema and apply on target from within SCT for this lab. The 4 tables in our Demo have basic design structures and can be migrated without changes between MSSQL and Aurora MySQL. We will use DMS to migrate the schema along with data in next steps.