Easy ReviewCLF-C02
Cloud Concepts4

DMS

Migrate data and replicate changes with AWS Database Migration Service.

Este conteúdo de estudo ainda não foi traduzido, então aparece em inglês. Ajude a traduzir

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.

Da documentação da AWS (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.

Da documentação da AWS (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

toque para virar
Resposta

·

Todos os 4 flashcards em lista

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.

Você concluiu todos os tópicos da CLF-C02!

Seu badge ficou dourado. Próximo passo: agendar a prova na AWS. Depois de passar, adicione-se ao Quem passou.

Compartilhar

Conte que você concluiu esta certificação

Concluí todos os tópicos da AWS Certified Cloud Practitioner (CLF-C02) no Easy Review. Venha estudar também!