Microsoft® SQL Server 2012 Unleashed

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