AWS Database Migration Service

Question 1

What is AWS Database Migration Service?

Answer 1

The DMS will help you migrate a database from DB-A to DB-B. This includes schema changes.

Question 2

What are the ways to migrate SQL databases to AWS, this includes using DMS?

Answer 2

• Using SQL servers native backup and restore
• SQL server replication
• Using DMS to bulk load the data and replicate on-going changes

Question 3

Is DMS a fully managed service?

Answer 3

It is a managed service but a VM is deployed into a VPC, this is the VM that is used to perform the database migration?

Question 4

What sources are supported?

Answer 4

• Mongo DB
• DB load and capture form S3
• Oracle
• MS SQL Server
• MySQL
• MariaDB
• Postgres
• Db2 LUW
• Azure SQL
• RDS database instances

Question 5

What are the target database types?

Answer 5

-Mongo DB
- DynamoDB
- Elastic search
Kinesis data streams
- DB load and capture form S3
- Oracle
- MS SQL Server
- MySQL
- MariaDB
- Postgres
- Db2 LUW
- Azure SQL
- RDS database instances

Question 6

What is a replication instance used for in DMS?

Answer 6

It is an instance or instance + standby in Multi-AZ that is used to replicate the data from DB-A to DB-B.

Question 7

What must you consider when selecting the replication instance?

Answer 7

The size, you need to select a size that will be large enough to give you the performance you need.

Question 8

How will the replication instance connect to the databases from its VPC?

Answer 8

There are two different situations, the replication instance gets a private IP and also can have a public IP. The public IP can be used what your database can be accessed over the public internet. The private IP can be used when VPN, directconnect or database is in the vPC. You can also connect using VPC peering.

Question 9

How is security handled for the DMS service?

Answer 9

Data at rest is encrypted, this is the replication instance data, using the KMS. SSL is used for connections

Question 10

Where does cloud migration service send its logs?

Answer 10

To the CloudWatch logs service.

Question 11

What is a DMS task?

Answer 11

You specify what tables and schemas to use for your migration and any special processing, such as logging requirements, control table data, and error handling.

Question 12

How does the DS perform the migration?

Answer 12

DMS performs the following functions,

• Copy or convert scheme to destination
• Copy data to the destination

Question 13

What is AWS SCT?

Answer 13

AWS SCT is the AWS schema conversion tool

Question 14

What are the source and target endpoints?

Answer 14

These are the source and target endpoints for each of the databases DMS will connect to for migration.

Question 15

What type of tasks can you have in DMS?

Answer 15

• Full load, this is where the entire database is copied in one shot.
• Full load and replication, this is where the database is copied and then ongoing replication happens.

Question 16

What is CDC

Answer 16

Change data capture, it is when a SQL database changes data in the tables, this data is captured so it can be replicated.

Question 17

What is full load?

Answer 17

This is when we are first performing database replication, we have to prefrom an initial load of all the data and after the load, CDC is performed and the changes replicated.