call us toll-free +1 855 855 3600
 
Home > Blog > First look at AWS Schema Conversion Tool with tighter DMS integration

First look at AWS Schema Conversion Tool with tighter DMS integration

Posted by | On | In Amazon Web Services, AWS Database Migration Service, Database Migration, OLTP Databases | Tags:
 

On December 20 2016, Amazon released version 1.0.502 of AWS Schema Conversion Tool (SCT). SCT now provides the integration with Data Migration Service (DMS)  and allows you to create AWS DMS endpoints and tasks. In addition SCT allows you to run and monitor the DMS tasks from SCT.

AWS SCT 502

AWS Database Migration Service helps you migrate databases to AWS easily and securely. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL.

As part of DMS integration, SCT introduced support for AWS profiles where users can store credentials for Amazon S3, AWS Lambda and DMS using the AWS Schema Conversion Tool interface. Finally, SCT now supports Amazon Aurora with PostgreSQL as a target database for conversion and migration projects.

Creating profiles

In order to use Data Migration Services inside the AWS Schema Conversion Tool, you must specify the required credentials. You can store the credentials in the corresponding Service Profile, which can be set up in the general application settings. To do so, click the Settings button, choose Global Settings, and go to the AWS Service Profiles tab.

AWS SCT Global Settings
Here you can add service profiles to enable access to other AWS resources (DMS, RDS, Lambda). Later, you will be able to switch between these profiles directly in the application.

AWS SCT service profiles

To set up the service profile, you have to specify its name, AWS Access and Secret keys, and the region. After the setup is completed, press the Save button.

AWS SCT Access and Secret keys

Preparing Data Migration

A typical database migration project usually consists of 12 basic steps. So, now the AWS Schema Conversion Tool to some extent (we mean fully or partially) covers the following steps described in our methodology:

  • Database schema conversion;
  • Application conversion / remediation;
  • Scripts conversion;
  • Data migration.

Before you can actually use the Data Migration Service, integrated into the Schema Conversion Tool, there are a few things that you need to address. First, you have to establish a connection to the source and target databases. Then you must convert schemas and apply them to the target database. This step is needed since DMS expects the tables to exist in the target database.

Using Data Migration Service

When this is done, you can move forward to creating a DMS task. To do so, just select the objects to migrate data from the source metadata tree and click ActionsCreate DMS task. Also, this option can be chosen from a pop-up menu after you right-click on selected objects.

creating a task in DMS

On the next step, you must specify the needed parameters to start the data migration process. They are the task name, the replication instance, and the source and target endpoints. Also, you can include or exclude the LOB columns, and enable logging for the operation.

AWS SCT creating database endpoint

When everything is set and the endpoints are created, just press the Create button. You will get to the Data Migration View window.

AWS SCT Data Migration View window

SCT puts the data migration task into the queue, however you still have to launch it manually.

AWS SCT Data Migration Integration 06

You can track its progress in the Data Migration View or switch back to your SCT project.

Tracking progress in the Data Migration View

When the data load is completed, we use Database Compare Suite to compare the tables in source and target databases.

Database Compare Suite table comparison

As you can see, SCT completed the data migration operation successfully.

Observations

Summarizing all features implemented in the new version of the AWS SCT, we can see that the tool is not only getting new features, but it is also becoming more user-friendly and intuitive. The expected and long-awaited update of  AWS Schema Conversion Tool brings integration of Data Migration Service for OLTP databases. Now you can perform and control all operations of an OLTP database migration project in one application — you don’t need to switch to another window anymore. For a complete overview of the new capability from AWS, check out Working with the AWS Database Migration Service Using the AWS Schema Conversion Tool.

Be sure to check out our new AWS Schema Conversion Tool Jumpstart offer to get you up and running fast for your AWS database migration projects.

Related AWS SCT Posts

 
       
 

Leave a Reply

  • CAPTCHA Image
    Play CAPTCHA Audio
    Reload Image