February 27, 2008 at 5:27 pm
Thought I share this clip:
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server thus making the details of the changes available in relational format.
For details:
http://channel9.msdn.com/ShowPost.aspx?PostID=368260
JasonL from Microsoft http://blogs.msdn.com/usisvde/
February 29, 2008 at 10:07 am
Thanks and this is an interesting feature.
August 18, 2008 at 5:56 pm
Just bumped into very informative article on CDC, thought I should share here with everyone.
August 28, 2008 at 3:44 am
I went on a 2008 launch event and they were pushing CDC as an auditing feature. I thought it was more for capturing intermediate changes to data for data warehouses (the way Oracle push it) - did anyone else get that impression from Microsoft?
August 28, 2008 at 12:54 pm
I see that CDC is designed to "share" log reading with replication. Does anyone know if this still works when you are using a remote Distributor? Wouldn't having both the remote distributor's log reader and a local log reader result in "disaster"? My understanding is that only one process can be in control of reading a log like this, but I haven't tried it yet.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply