All services

Migration & Transfer

AWS Database Migration Service

Migrate and replicate databases with minimal downtime.

Official docs

Overview

DMS migrates between homogeneous (MySQL→MySQL) and heterogeneous (Oracle→PostgreSQL) databases with CDC for ongoing replication.

When to use it

  • Lift-and-shift DB migrations
  • CDC into data lake
  • Cross-region replication

Setup

  1. Create replication instance, source + target endpoints, then a task (Full Load / CDC / both).

How to use

Start task
aws dms start-replication-task --replication-task-arn ... --start-replication-task-type start-replication

QA use cases

  • Continuously replicate prod → QA (with masking) so QA always tests on near-real data.