SQL Server 2012 CDC queries

dataservices job design
1

Hi ,

We are going to implement the CDC on SQL Server 2012 source system.

I have few queries on that.

  1. SQL Server 2012 is creating the extra CDC tables in the operational database . What is the overhead of these tables in the operational system.

  2. SQL Server 2012 CDC replication method is log based or trigger based method?

  3. For implement the CDC do we need Primary key ? If table without primary not permit to create CDC?

  4. In the CDC table we have the option “Automatically delete rows after reading” . Is it delete the all records in the CDC table or only read records only?

  5. If I apply Automatically delete rows after reading option on the CDC source table if my job got failed before loading into the target how can get the CDC records for next re-run?

Please help me on this queries .

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)

2

You might be able to find answers to some of your questions here:-

http://wiki.scn.sap.com/wiki/display/EIM/How+To+-+typical+DataServices+questions

Unfortunately, there isn’t a specific section for SQL Server 2012 CDC.

Nemesis :australia: (BOB member since 2004-06-09)