CDC objects and Source Control

rickbergfalkrickbergfalk Posts: 2
edited June 10, 2013 8:18AM in SQL Source Control Previous Versions
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!
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    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...
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.