Using Schema Conversion Tool

  1. Inside the SCT Tool, let’s first connect to our Source SQL Server Database:

    • Click Connect to Microsoft SQL Server

    Setting Value
    Server name (SQL Server Private IP)
    Server port 1433
    Instance name (blank)
    Authentication SQL Server Authentication
    User name awssct
    Password (password)
    • Test the connection
    • Click OK
    • You might get this warning:
      In which case, just ignore and close.
  2. Once the Source SQL Server is connected, let’s now try connecting to the target Aurora (MySQL Serverless) Database:

    • Click Connect to Amazon Aurora (MySQL compatible)

    Setting Value
    Server name (Aurora MySQL Endpoint)
    Server port 3306
    User name awssct
    Password (password)
    • Test the connection
    • Click OK
    • You might get this warning:

      In which case, just ignore and close.
  3. After both the Source and Target databases have been loaded, we can now create a Migration Report:

    • Right-click on the sampledb from the Source Database, then click on Create Report

    • It will now generate a Migration assessment report, that should give you a good overview of what can be migrated automatically, and some action items that require attention.
      Screenshot of Summary

      Screenshot of Action Items