0Pricing
AWS Solutions Architect · Lesson

Database Migration Service (DMS) and Schema Conversion Tool

Migrate homogeneous and heterogeneous databases with DMS using full-load or CDC, and convert schema dialects with the Schema Conversion Tool.

What Is AWS DMS?

AWS Database Migration Service (DMS) migrates databases to AWS with minimal downtime. It supports homogeneous migrations (e.g., Oracle to Oracle, MySQL to MySQL) and heterogeneous migrations (e.g., Oracle to Aurora PostgreSQL, SQL Server to MySQL). DMS uses a replication instance that reads from the source, optionally transforms data, and writes to the target. You pay only for the replication instance runtime.

DMS Components: Endpoints, Replication Instance

DMS has three key components. Source Endpoints define the source database connection (JDBC URL, credentials, TLS). Target Endpoints define the destination database. The Replication Instance is an EC2-based managed server that DMS provisions in your VPC to run the migration workload. Choose the replication instance size based on how much data needs to be migrated and whether you want multi-AZ for the replication instance itself.

# Create a DMS replication instance
aws dms create-replication-instance \
  --replication-instance-identifier my-dms-instance \
  --replication-instance-class dms.t3.medium \
  --allocated-storage 50 \
  --vpc-security-group-ids sg-abc123 \
  --replication-subnet-group-identifier my-dms-subnet-group \
  --multi-az false \
  --publicly-accessible false

All lessons in this course

  1. The 7 Rs of Migration Strategy
  2. AWS Migration Hub and Application Discovery Service
  3. Application Migration Service (MGN)
  4. Database Migration Service (DMS) and Schema Conversion Tool
← Back to AWS Solutions Architect