DEV Community

Cover image for How to use DMS services
Leonard Hermawan
Leonard Hermawan

Posted on

How to use DMS services

DMS is a fully managed service that enables migration and continuous data replication from on-premises, cloud, or hybrid databases to AWS with minimal downtime. It supports heterogeneous and homogeneous migrations.
Setting Up a Replication Instance
First, we must set up a replication instance. One advantage of AWS DMS is that it does not require a license—we only pay for the virtual machine (VM) used.
For production purposes, we can choose a multi-AZ (Availability Zone) deployment to enhance availability and fault tolerance.

Image description

Configuring the Source Endpoint
Next, we must create a source endpoint for AWS DMS to connect to. In my case, the source is located in an AWS VPC, but we can also use an on-premises server or another cloud provider.

Image description

Once AWS DMS successfully connects, the source endpoint status will change to Active. We must also create a target endpoint and ensure that both the source and target endpoints have an Active status.

Image description

Image description

To verify connectivity, we can use the Test Endpoint feature in AWS DMS.

Image description

Creating a Migration Task
After configuring the endpoints, we need to set up an AWS DMS migration task by selecting the source and target databases.

Image description

For the migration type, we can choose from:

  1. Full Load – Migrates all data in one go.
  2. Full Load and CDC (Change Data Capture) – Performs a full migration and continues replicating changes in real-time.
  3. CDC Only – Captures and replicates only the incremental changes. I used Full Load and CDC for real-time replication of delta changes. It is recommended to enable CloudWatch monitoring to track the performance of the replication task.

Image description

Filtering and Migrating Data
We can filter and specify which schemas or tables to migrate to AWS and which ones to exclude.

Image description

Once everything is set up, the migration task will start, and the data will begin replicating to the target database.

Image description

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs