Database migration using AWS DMS service

27 May 2021

AWS Database Migration Service (AWS DMS) is used to migrate your data to and from most widely used commercial and open-source databases such as Oracle, PostgreSQL, Microsoft SQL Server. AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.

Create a replication instance using the AWS DMS console

A replication instance performs the actual data migration between source and target endpoints. Your instance needs enough storage and processing power to perform the tasks that migrate data from your source database to your target database.

• Steps to create a replication instance.
• • Sign in to the AWS Management Console
  • Choose the region and click on the replication instance then click on create replication instance.
  • On the Create replication instance page, fill the information for your replication instance such as Name, Description, Allocated storage, VPC.
  • Click on the create button.

Specify source and target endpoints

After a replication instance is created you will need source and target endpoints to specify the source and target databases.

• Steps to create a source endpoint:
  • Click on Endpoints from the navigation pane.
  • On the create endpoint page select the Source endpoint.
  • Enter the name for Endpoint identifier field.
  • For the Source engine field, choose the type of database engine you want this endpoint to connect.
  • Select the VPC and Replication instance for the endpoint.
  • You can test the endpoint configuration by clicking on the Run Test button.
  • Click on the create button to create the endpoint.

• Steps to create a target endpoint:
  • Click on Endpoints from the navigation pane.
  • On the create endpoint page select the Target endpoint.
  • Enter the name for Endpoint identifier field.
  • For the Source engine field, choose the type of database engine you want this endpoint to connect.
  • Select the VPC and Replication instance for the endpoint.
  • You can test the endpoint configuration by clicking on the Run Test button.
  • Click on the create button to create the endpoint.

Create a task and migrate data

To migrate the data you need to create a task to specify what tables to migrate. Your task also maps data using a target schema and creates new tables for the target database.

• Steps to create a task for database migration:
  • Click on Database migration tasks from the navigation pane click on Create task button.
  • Fill the details about Task Configuration.
  • Enter the unique identifier for the task.
  • Select the source and target endpoints for the task.
  • Select the type of the migration.
  • Click on the create task button.

Monitor your task

You can monitor the tasks that are running for the database migration.

1. In the DMS console navigation pane, choose Database migration tasks.
2. Choose the name of the running task that you want to monitor.
3. Choose Table statistics.