Change Data Capture CDC and AWS DMS Replication
Change Data Capture (CDC) is the process that identifies and captures the changes made to the last refreshed data or metadata with periodicity fixed at minutes or even seconds. The changes made are entered in a separate data repository by specific software. Similar to batch loads, CDC ensures that the replication software copies one source to several targets. AWS DMS is a cloud-based service that facilitates easy migration of relational databases, data warehouses, NoSQL databases through AWS DMS CDC . It can also be used for migrating data to the AWS cloud or on-premises setup or a combination of both. Since AWS DMS is a component of the AWS cloud, it has all the features of AWS cloud services like cost efficiency, speed to market, security, and flexibility. An AWS DMS CDC can be created for capturing current changes to the source data during the replication process. Regardless of whether the work is a CDC-only task or a full-load one the migration process has tables only fr...