Skip to content
Marco's Learning

Database Migration Service (DMS)

  • Quickly and securely migrate databases to AWS, resilient, self healing
  • The source database remains available during the migration
  • Supports:
    • Homogeneous migrations: ex. Oracle to Oracle
    • Heterogeneous migrations: ex SQL Server to Aurora
  • Continuous data replication using CDC
  • You must create an EC2 instance to perform the replication tasks

DMS Sources and Targets

SourcesTargets
On-Premises and EC2 instance databases
Azure
Amazon RDS
Amazon Aurora
Amazon S3
DocumentDB		On-Premises and EC2 instance databases
Amazon RDS
Redshift
DynamoDB
S3
OpenSearch Service
Kinesis Data Streams
Apache Kafka
DocumentDB
Amazon Neptune
Redis
Babelfish

AWS Schema Conversion Tool (SCT)

  • Convert your database’s schema from one engine to another
  • Example OLTP: (SQL Server or Oracle) to MySQL, PostgreSQL, Aurora
  • Example OLAP: (Teradata or Oracle) to Amazon Redshift
  • You do not need to use SCT if you are migrating the same DB engine
    • Ex: On-Premise PostgreSQL => RDS PostgreSQL
    • The DB engine is still PostgreSQL, RDS is the platform

DMS - Continuous Replication

DMS/CDC

DMS - Multi-AZ Deployment

DMS/MultiAZ

  • When multi-AZ is enabled, DMS provisions and maintains a synchronously stand replica in a different AZ
  • Advantages:
    • Provides data redundancy
    • Eliminates I/O freezes
    • Minimizes latency spikes