Microsoft® SQL Server 2012 Unleashed

Change Data Capture

Recently, the Change Data Capture (CDC) capabilities have become much more stable and more tightly integrated into SQL Server. As illustrated in Figure 39.10, a change process is running that reads any change transactions from the transaction log and pushes them to a series of change tables. CDC does require that table objects and some CDC stored procedures be added to your SQL Server instance that is a source of data to be replicated. The CDC process and change table activity also adds overhead to the source SQL Server. Another CDC process (invoked via the SQL Agent) reads, transforms, and writes the table changes to another SQL Server database (target). This target can then be used for reporting or as a warm standby. The ...