call us toll-free +1 855 855 3600
 
  • Home
  • >
  • Blog
  • >
  • First look at AWS Schema Conversion Tool with tighter DMS integration
DB Best Chronicles
 
Talks on Big Data, Mobile Apps, Web and Software Development

First look at AWS Schema Conversion Tool with tighter DMS integration

Posted by | On January 3rd, 2017 | In AWS, Database Migration | 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 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 10 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 Data Migration Integration 01

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 DMS Integration 22

Using Data Migration Service

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.

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.

AWS SCT DMS Integration 33

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 DMS Integration 44

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 DMS Integration 5

The data migration task will be put into the queue, however it should still be launched manually.

AWS SCT Data Migration Integration 06

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

AWS SCT DMS Integration 777

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, the data migration operation was completed successfully.

 

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 integration of Data Migration Service for OLTP databases into AWS Schema Conversion Tool is an expected and long-awaited update. 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

 

Comments

comments


Leave a Reply