Create a Database Migration Project


Now that you have installed the AWS Schema Conversion Tool, the next step is to create a Database Migration Project using the tool.

  1. Within the Schema Conversion Tool, enter the following values into the form and then click Next.

    Parameter Value
    Server Name AWS Schema Conversion Tool SQL Server to Aurora PostgreSQL
    Location C:\Users\Administrator\AWS Schema Conversion Tool
    Database Type Transactional Database (OLTP)
    Source Database Engine Microsoft SQL Server / I want to switch engines and optimize for the cloud

    \[SqlSct05\]

  2. Specify the source database configurations in the form, and click Test Connection. Once the connection is successfully tested, click Next.

    Parameter Value
    Server Name localhost
    Server Port 1433
    Instance Name
    Authentication SQL Server Authentication
    User Name awssct
    Password Password1
    Use SSL Unchecked
    Store Password Checked
    Microsoft SQL Server Driver Path C:\Users\Administrator\Desktop\DMS Workshop\JDBC\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar

    \[SqlSct06\]

You may see a security warning prompt to use SSL. Click on “Accept the risk and continue” button.

\[SqlSct06b\]

  1. Select the dms_sample database, then click Next. (Note: click on database name & gray/blue bar highlight should appear & Next button will be enabled)

    \[SqlSct07\]

After hitting Next and loading metadata, you may get a warning message saying: Metadata loading was intrupted because of data fetching issues. You can ignore this message as it doesn’t affect us in this workshop.

  1. Review the Database Migration Assessment Report. Note: it automatically includes MySQL, PostgreSQL & MariaDB. You’ll be interested in PostgreSQL part.

    \[SqlSct08\]

SCT will examine in detail all of the objects in the schema of source database. It will convert as much as possible automatically and provides detailed information about items it could not convert. Please scroll down to the Aurora PostgreSQL section. \[SqlSct09\]

Generally, packages, procedures, and functions are more likely to have some issues to resolve because they contain the most custom or proprietary SQL code. AWS SCT specifies how much manual change is needed to convert each object type. It also provides hints about how to adapt these objects to the target schema successfully.

  1. After you are done reviewing the database migration assessment report, click Next.

  2. Specify the target database configurations in the form, and then click Test Connection. Once the connection is successfully tested, click Finish.

    Parameter Value
    Target Database Engine Amazon Aurora (PostgreSQL compatible)
    Server Name < TargetAuroraPostgreSQLEndpoint >
    Server Port 5432
    Database AuroraDB
    User Name dbmaster
    Password dbmaster123
    Use SSL Unchecked
    Store Password Checked
    PostgreSQL Driver Path C:\Users\Administrator\Desktop\DMS Workshop\JDBC\postgresql-42.2.9.jar

    \[SqlSct10\]

You may see a warning message regarding the database engine version. You can ignore the warning.

You may see a security warning prompot to use SSL. Click on “Accept the isk and continue” button.