Change Data Capture: SQL 2005 Source

Question

From what I know, the Change Data Capture that SQL Server 2012 uses is powered by the Attunity tool set. I know that with Attunity, you can have a SQL 2005 server be the source for data. Is this possible with the SSIS 2012 components? From what I can see, Change Data Capture is only supported on SQL Server 2008 Enterprise and up. If this is the case, how does Attunity have the ability to do it?

Thanks,

Chris

Answer 1

The CDC Components in SSIS 2012 leaverage the CDC capabilities of the relational engine available since SQL Server 2008 (Enterprise edition only).

Atunity does have a different toolset that implements its own log reader to harvest transactions but that is not how the SSIS CDC components work.

Regards,

Luis

Answer 2

Here is a link that explains how CDC components work on SSIS 2012. You will notice the requirment of enabling CDC on the relatioinal engine before been able to use this components:

http://msdn.microsoft.com/en-us/library/bb895315.aspx

Luis Figueroa @luisefigueroa