Articles → AWS → AWS Schema Conversion Tool

AWS Schema Conversion Tool

In this article, we will discuss the AWS schema conversion tool.

Purpose

AWS schema conversion tool (SCT) is used to migrate the schema from the source database to the target database. Please note that the data is not migrated using the AWS schema conversion tool.

Schema Conversion

In this article, we will migrate an on-premises MSSQL database to RDS. For that, we will work on the following steps: -

Download the required components
Specify MSSQL drivers in AWS SCT settings
Create an MSSQL database in AWS RDS
Create a project inside AWS SCT
Connect to the source and target database
Migrate database schema

So, let us get started.

Download The Required Components

First, we will download the AWS schema conversion tool and MSSQL JDBC drivers. Once the AWS schema conversion tool is downloaded, install the tool on your machine.

Specify MSSQL Drivers In AWS SCT Settings

The second step is to specify the MSSQL JDBC drivers. For that: -

Open AWS Schema Conversion Tool
Go to Settings → Global settings

Picture showing the Global settings submenu inside the Settings menu

Inside the Drivers tab, you can specify the path of JDBC drivers downloaded in the previous section

Click on the Ok button

Create An MSSQL Database In AWS RDS

Create an MSSQL database in AWS RDS. You can follow this link to create a database.

Create A Project Inside AWS SCT

First, open AWS SCT. For creating the new project, click on File → New project….

Picture showing the New Project... option for creating the new project

A popup window will appear where you can specify the Project name and Location. Click on the OK button to create the project.

The project is created.

Picture showing the new project created in AWS schema conversion tool

Connect To The Source And Target Database

Once the project is created, connect to the source and the target database. For that, you have an option Add source and Add target in the AWS SCT.

Picture showing the Add source and Add target button for adding the source and target database

First, click on the Add source button. A popup window will appear where you can specify the source database category.

Picture showing selecting the Microsoft SQL Server as source database

For this article, we are selecting Microsoft SQL Server. Click on the Next button. In the next window, you can specify the credentials. Click on the Connect button.

Picture showing a window to enter the credentails of the source database

The metadata loading will start.

Picture showing a window to show the progress of metadata loading

In the similar manner, click on the Add target to add the target database credentials. For target, we will select the database category as Amazon RDS for Microsoft SQL Server.

Picture showing selecting the Amazon RDS for Microsoft SQL Server as target database type

Once you click on the Next button. Like source, fill the credentials and then metadata will load.

Please note → The source and database name should be the same.

Migrate Database Schema

First, go to the Main view → Main view.

Picture showing an option to switch to the Main view

In the source server, right-click on the schema and click on the Create mapping….

Picture showing the Create mapping option for creating a mapping between the source and target database

The following window will appear. Click on the Create mapping button.

Picture showing the Create mapping option for creating a mapping button between the source and target database

The mapping is created.

Go to the main view again. In the source database, right-click on the schema and click on the Convert Schema option.

Picture showing the Convert Schema option for copying the schema to target database

Following message will appear.

Picture showing the confirmation message of the convert schema option

Click on Yes. On the target database, right-click and click on Apply to database

Picture showing the Apply to database option for applying the schema changes to target database

A confirmation message will appear. Click on Yes.

Picture showing the confirmation message for apply to database

The database schema will be migrated.

Posted By -	Karan Gupta

Posted On -	Thursday, March 10, 2022

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**