Articles → AWS → AWS Schema Conversion Tool

AWS Schema Conversion Tool






Purpose





Schema Conversion




  1. Download the required components
  2. Specify MSSQL drivers in AWS SCT settings
  3. Create a MSSQL database in AWS RDS
  4. Create a project inside AWS SCT
  5. Connect to the source and target database
  6. Migrate database schema



Download The Required Components





Specify MSSQL Drivers In AWS SCT Settings




  1. Open AWS Schema Conversion Tool
  2. Go to "Settings" → "Global settings"
  3. Picture showing the Global settings submenu inside the Settings menu

    Click to Enlarge

  4. Inside the "Drivers" tab, you can specify the path of JDBC drivers downloaded in the previous section
  5. Picture showing the popup window to specify the JDBC drivers for MSSQL

    Click to Enlarge

  6. Click on the "Ok" button

Create A MSSQL Database In AWS RDS





Create A Project Inside AWS SCT




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

Click to Enlarge



Picture showing a popup window for specifying the name and location of the project

Click to Enlarge



Picture showing the new project created in AWS schema conversion tool

Click to Enlarge


Connect To The Source And Target Database




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

Click to Enlarge



Picture showing selecting the Microsoft SQL Server as source database

Click to Enlarge



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

Click to Enlarge



Picture showing a window to show the progress of metadata loading

Click to Enlarge



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

Click to Enlarge






Migrate Database Schema




Picture showing an option to switch to the Main view

Click to Enlarge



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

Click to Enlarge



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

Click to Enlarge



Picture showing the mapping is created between the source and target database

Click to Enlarge



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

Click to Enlarge



Picture showing the confirmation message of the convert schema option

Click to Enlarge



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

Click to Enlarge



Picture showing the confirmation message for apply to database

Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Thursday, March 10, 2022

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250