O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required