Bitzu

SAA-C03 ยท Cost management, databases and network costs

Database migration with AWS DMS and schema conversion

Homogeneous versus heterogeneous migrations, AWS DMS for data and ongoing replication (CDC) and schema conversion for engine changes.

Key points

  • Homogeneous: same engine family (MySQL to RDS for MySQL); no schema conversion.
  • Heterogeneous: engine changes (Oracle to Aurora PostgreSQL); convert schema and code first with DMS Schema Conversion or AWS SCT, then DMS moves data.
  • Schema conversion never moves data.
  • DMS tasks: full load, full load + CDC, CDC only.
  • CDC reads transaction logs (MySQL row-based binlog); source stays online, short cutover; no latency SLA.

Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SchemaConversion.html

Practice questions

Single choice

Which AWS DMS migration type copies the existing data and then keeps applying new changes from the source?

  1. Full load only
  2. Full load plus CDC
  3. CDC only
  4. Schema conversion only
Show answer

Answer: B. Full load plus CDC

Full load plus CDC first loads the existing tables and then replicates ongoing changes, which keeps the target in sync until cutover. Full load alone stops after the copy; CDC only assumes the data is already on the target; schema conversion does not move data at all.

Select all that apply

Which statements about AWS DMS and DMS Schema Conversion are correct?

  1. DMS Schema Conversion converts the schema but does not move data
  2. DMS CDC reads changes from the source database's transaction logs
  3. A MySQL source needs row-based binary logging for CDC
  4. Homogeneous migrations always need schema conversion first
  5. DMS CDC guarantees real-time replication backed by an SLA
Show answer

Answer: A. DMS Schema Conversion converts the schema but does not move data, B. DMS CDC reads changes from the source database's transaction logs, C. A MySQL source needs row-based binary logging for CDC

DMS Schema Conversion converts schemas, not data; DMS CDC reads changes from the source engine's logs; and a MySQL source needs row-based binary logging for CDC. A homogeneous migration keeps the engine, so no schema conversion is required, and AWS states that DMS CDC is not real-time and has no latency SLA.

True or false

An AWS DMS replication task automatically rewrites Oracle PL/SQL stored procedures into PostgreSQL code while it copies the data.

Show answer

Answer: False

False. A DMS replication task moves data. Converting code objects such as procedures and functions is the job of DMS Schema Conversion or AWS SCT, done before the data migration; objects that cannot be converted automatically need manual work.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More SAA-C03 topics in this module