DMS

Question 1

What is DMS - Database Migration service?

Answer 1

AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your database and analytics workloads to AWS quickly, securely, and with minimal downtime and zero data loss. AWS DMS supports migration between the 20-plus database and analytics engines

it supports:

1. Homogeneous migration: Oracle to Oracle migration
2. Heterogeneous migration: oracle to Aurora

it supports continuous data application using CDC (Change data capture).

To use DMS, you must create EC2 to perform replication task

Question 2

What is schema conversion tool (SCT)?

Answer 2

it converts your database schema from one engine to another.

Example: converting schema in SQL server for MySQL or Aurora.

Question 3

What is the difference between DMS and Schema Conversion Tool

Answer 3

AWS Database Migration Service or AWS DMS provides shifting of your data to AWS. This service enables you to migrate all the data securely. This service is even more helpful because your data source will remain operational throughout the migration process. Change Data Capture (CDC) is a feature that enables you to copy data for migration using AWS DMS. CDC enables an uninterrupted flow of data as it is replicated.

AWS Schema Conversion Tool is a free-of-cost feature that comes with AWS Data Migration Service. This free part of the service is given a different name.

AWS SCT is a service that brilliantly automates the entire conversion from one database to another.

Databases like Oracle PL/SQL and SQL Server T-SQL code are usually where the schema is picked up from.

Schema from such database tools is then converted into equivalent codes in the Amazon Aurora/MySQL dialect of SQL.

Question 4

What is DMS - Continous Replication?

Answer 4

DMS Continuous Replication is a feature of AWS Database Migration Service (DMS) that enables continuous data replication from a source database to a target database in near real-time. It uses log-based replication to capture changes made to the source database and applies those changes to the target database without interrupting normal database operations. Continuous Replication ensures minimal data loss and downtime during the migration process and is ideal for applications that require high availability and minimal downtime. It supports a variety of database engines including Amazon RDS, Amazon Aurora, and self-hosted databases.

STC is installed in the data center whereas DMS is installed in the EC2 instances