Migration Flashcards
Regarding database migration, what is SCT and what does it do?
Schema Conversion Tool
Allows you to convert database schemas from one engine to another.
What is DMS on a high level?
A server running replication software
What are the database migration steps when using DMS? (5)
- Create Source and Target connections
- Migrate the database Schema
- Set up the data replication process
- Initiate the full load (and a subsequent CDC) and apply
- Switch your production environment to the new database
Step 5 doesn’t apply to CDC only migrations.
TRUE or FALSE?
DMS cannot migrate between source and target endpoints that have different engines.
FALSE
It can, using the Schema Conversion Tool
TRUE or FALSE?
You can use AWS Schema Conversion Tool to convert databases running on EC2 or data stored in S3
TRUE
What are the 3 different database migration types to know for the exam?
- Full Load
- Full Load and Change Data Capture (CDC)
- CDC only
What is Full Load migration?
All existing data from the source is moved to the target.
What is Full Load and CDC migration?
All existing data from the source is moved to the target.
CDC captures changes to the source tables during migration.
Which AWS services would you use to migrate large data stores?
AWS Snowball with DMS
What problem can occur when migrating large data stores?
Network throttling
What is a CDC only migration?
It does not move any pre-existing data.
Only the changes that occur on the source database after the migration starts are moved.
What are some use cases for a CDC only migration? (3)
- Logging what data has changed
- Replicating data between different environments (e.g. development and testing)
- Real time data integration (i.e. to feed data into other systems in real time, e.g. for analytics)
TRUE or FALSE?
When using DMS, one of the endpoints must be within AWS.
TRUE
What does SMS stand for?
Server Migration Service
Migration Hub is a place to… (3)
- Discover existing servers
- Plan migrations
- Track migration status
It works with other services to actually do the migrations.