Migration of on-premises data to Amazon DynamoDB using Amazon Database Migration Service.

In this project based in a real-world scenario, I acted as the Cloud Engineer to migrate data from on-premises PostgreSQL to Amazon DynamoDB database using AWS Database Migration Service(DMS).

Below are few screenshots:

Created Aurora PostgreSQL instance compatible to on-premises database

On premises PostgreSQL database

Copy the endpoint

Use the endpoint in the on-premises PostgreSQl host address

Create database

Create table and insert data into it

We can query the inserted data in the on-premises database

Create AWS Database Migration Service

Create a replication instance first

Create endpoints

Creating IAM policy for DMS

Created endpoints for source and target

Creating Replication instance

Test the endpoint connection

Test successful

Creating database migration task

Database migration task completed

Starting the database migration task

Running

Load complete

The data is available in the AWS DynamoDB table

Added one more record in the on-premises database table

Restart the database migration task

The new record that has been added is available in the AWS DynamoDB table