CDC objects and Source Control

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

CDC objects and Source Control

Postby rickbergfalk » Fri Jun 07, 2013 7:18 pm

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!
rickbergfalk
 
Posts: 1
Joined: Fri Jun 07, 2013 5:39 pm

Postby james.billings » Mon Jun 10, 2013 1:18 pm

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...
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest