Easy ReviewCLF-C02
Cloud Concepts4

DMS

Migrate data and replicate changes with AWS Database Migration Service.

AWS DMS copies data and can apply ongoing changes to support a controlled cutover.

DMS basics

AWS DMS moves data from one database to another, including into AWS, and can keep them in sync during the move.

How it works

  1. Connect DMS to the source and target databases.
  2. Copy the existing data.
  3. Optionally replicate ongoing changes until cutover.

Exam cues

  • If the question says migrate a database to AWS with little downtime, think AWS DMS.

Remember

  • One-time migration or ongoing replicationChange data capture reads ongoing changes from a source data store so they can be replicated..

Trap: DMS moves data; converting the schemaA database schema defines database objects such as tables, views and functions. between different engines uses schema conversion tools.

From the AWS docs (2)
  • AWS Database Migration Service (AWS DMS) migrates relational databases, data warehouses, NoSQL databases and other data stores into AWS or between cloud and on-premises setups.
  • AWS DMS can do a one-time migration or replicate ongoing changes to keep source and target in sync.

Schema conversion

When a database moves to a different engine, such as Oracle to Amazon Aurora PostgreSQL, its schemaA database schema defines database objects such as tables, views and functions. has to be converted before the data can follow. That conversion covers tables, views and code. AWS SCT and DMS Schema Conversion do it; AWS DMS moves the data.

How it works

  1. Create a migration project with source and target databases.
  2. Convert the schema for the target database.
  3. Migrate the data with AWS DMS, with change data captureChange data capture reads ongoing changes from a source data store so they can be replicated. if the source stays live.
Migration Schema step Data step
Same engine (homogeneous), such as MySQL to Amazon RDS for MySQL Usually none AWS DMS
Different engine (heterogeneous), such as Oracle to Aurora PostgreSQL AWS SCT or DMS Schema Conversion AWS DMS

Exam cues

  • If the question says change database engines, think schema conversion first, then AWS DMS for the data.

Remember

  • Schema conversion converts structure and code, not data.
  • Targets include Amazon RDS engines, Aurora and Redshift.

Trap: AWS DMS alone does not rewrite an Oracle schema for PostgreSQL. A heterogeneous migration needs schema conversion too.

From the AWS docs (4)
  • The AWS Schema Conversion Tool (AWS SCT) converts an existing database schema from one database engine to another, for OLTP or data warehouse schemas.
  • AWS SCT output suits Amazon RDS for MySQL, MariaDB, Oracle, SQL Server and PostgreSQL, Amazon Aurora and Amazon Redshift, and can also be used with a database on Amazon EC2.
  • DMS Schema Conversion is a feature of AWS DMS that converts source schemas to a format compatible with Aurora, Amazon RDS or Amazon Redshift.
  • DMS Schema Conversion converts the database schema, not the data; data migration uses the data migration features of AWS DMS.

Flashcards

tap to flip
Answer

·

All 4 cards as a list

A company must move an on-premises Oracle database to AWS while it keeps serving users. Which service copies the data and the ongoing changes?

AWS Database Migration Service (AWS DMS), with ongoing replication.

Can AWS DMS keep a source and target database in sync after the first copy?

Yes. It replicates ongoing changes after the initial migration.

A company is migrating an Oracle database to Amazon Aurora PostgreSQL. Which AWS tools convert the schema?

AWS Schema Conversion Tool (AWS SCT) or DMS Schema Conversion. AWS DMS then migrates the data.

Does AWS Schema Conversion Tool also copy the data to the new database engine?

No. Schema conversion converts the schema; AWS DMS migrates the data.

You finished every topic of CLF-C02!

Your badge turned gold. Next step: book the exam on AWS. Once you pass, add yourself to Who passed.

Share

Share that you finished this certification

I finished every topic of AWS Certified Cloud Practitioner (CLF-C02) on Easy Review. Come study too!