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

CDC is a poor man’s method of getting updates, deletes, and inserts from one database to another via the log reader. It uses a set of stored procedures and tables (change tables) on the source database side, but then pumps those data changes over to a target database pretty darn quickly with 100% data integrity. CDC as a DR option makes sense for those that can afford this type of data lag and who don’t mind having a spare DR site that is only as up-to-date as the last set of pushed changes (which is pretty darn good). Significant setup is required of change tables, additional stored procedures, and so on. It is not guaranteed to be real time, and sometimes resynchronizations need to be done to get the tables back in line. ...

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