Thread: CDC
View Single Post
  #1 (permalink)  
Old October 20th, 2008, 11:06 AM
vijayig vijayig is offline
Registered User
Join Date: Oct 2008
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default CDC

Hi All,

I am a data warehouse developer.
I need to design and conduct an "INCREMENTAL LOAD" for my SQLSERVER 2005 source database.

I came to know that there is an inbuilt mechanism "CDC(CHANGE DATA CAPTURE)" is available in SQLSERVER 2008.
Is that same kind of mechanism is enabled is SQLSERVER 2005,
Else what would be the best approach to deal with capturing the changed data.