🔷
DMS – Continuous Replication
- Scenario: Continuous replication from an on-premises database to AWS.
- Architecture:
- Corporate Data Center: Oracle DB (source)
- AWS VPC:
- Public Subnet: AWS DMS Replication Instance (initial load + CDC)
- Private Subnet: Amazon RDS for MySQL (target)
- Process:
- Schema Conversion: Use AWS SCT on a separate server to convert Oracle schema to MySQL.
- Data Migration:
- Full Load: Initial migration of all data.
- CDC: Ongoing replication for near real-time sync.
- Benefit: Enables seamless heterogeneous migration with minimal downtime.