CDC objects and Source Control

rickbergfalk

Is there a recommended practice for handling SQL Server CDC objects when using Source Control?

Source control tracks the user, schema, role, and table valued functions created, but does not seem to track the cdc System Tables.

Is it best to just leave CDC objects and configuration out of Source Control? Or implement them only via migration scripts?

Any advice or first-hand experience is much appreciated!

James B

I'm not sure as to a "recommended" method- but it's correct that we don't track "system" level objects (this is a limitation of the SQL Compare engine which Source Control uses behind the scenes).

I guess manipulating these objects behind the scenes may well work, although it's not something I've tried personally...