What is Change Data Capture to A SQL Server Table
SQL Server Change Data Capture (CDC) is a technology that monitors insert, update and delete activities applicable to a SQL Server table. This results in the details of the changes being available in a relational format that is easy to understand. The metadata and the column information required to apply the changes to a target database are captured for the modified rows and stored in change tables that replicate the column structure of the tracked source tables. Users are provided with table-valued functions that permit methodical access to the change data by consumers.
An example will explain this point. Consider that the data consumer targeted by the CDC technology is an ETL (Extract, Transform, Load) application. In SQL Server Change Data Capture, the ETL application incrementally loads change data from SQL Server source tables to a data mart or a data warehouse.
However, even though the source tables in the data warehouse reflect the changes made in the source tables, a technology that refreshes a replication of the source only is not enough. Instead, what is needed is a dependable stream of change data that is so structured that it can be applied to dissimilar target representations of the data. SQL Server Change Data Capture provides this technology.
Before undertaking SQL Server Change Data Capture, users have to carry out a few basic steps.
The SQL Server must be configured for full backup with the recovery model set to Full or Bulk logged. Next, it should be ensured that the SQL Server supports backup to multiple disks, as otherwise AWS DMS will not be able to read the data and the activity will fail.
Comments
Post a Comment