Cianplan

Level 4: Reliability, security & cloud · L4.6 AWS architecture decisions (SAA-C03)

Migrating databases and bulk data: DMS, schema conversion and CDC

Plan a database migration with AWS DMS (full load, full load plus CDC, homogeneous or heterogeneous with schema conversion first), and choose DataSync, Transfer Family, Storage Gateway or an offline path for the files, knowing which options are closed to new customers.

13 min · Pro

What you take away

  • DMS moves data; DMS Schema Conversion or the Schema Conversion Tool (SCT) converts the schema. An engine change needs the schema converted first.

And 3 more inside the class, in Pro.

How the class is laid out

  1. The problem
  2. The simple version
  3. Schema first, then data
  4. The files around the database
  5. Check your understanding