Choosing which Tables to add to source control

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

Choosing which Tables to add to source control

Postby robnikkel » Thu Oct 27, 2011 6:16 pm

I'm new to SQL Source Control, but I currently haven't found any way to manually select which tables I actually want to source control. Looks like the only thing I can play with in terms of deciding what schema to source control is using the filtering tool.

The problem is that we have several dynamically created tables in our DB as we work with the application. We don't want these automatically detected and added to source control. If I have to setup filters, they would be numerous and cumbersome to maintain with the lack of RegEx support.

Has anyone else come across this?


Posts: 4
Joined: Thu Oct 27, 2011 6:11 pm
Location: Vancouver, BC

Postby eddie davis » Mon Oct 31, 2011 10:50 am

Thank you for your post into the forum.

Please take a look at this SQL Source Control help ARTICLE.

The article explains how to use filters to exclude objects from source control.

Please reply to this post, if you need further assistance.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby robnikkel » Mon Oct 31, 2011 2:45 pm


I appreciate the link, but I've already played with the tool, and was hoping for some more advanced features for excluding/including schema. For example, regular expressions, or even the ability to manually decide whether a table is source controlled or not (check list). In the time being, we're going to have to change our DB to create dynamic tables in a schema we don't want source controlled and then put a filter to exclude tables contained in it.


Posts: 4
Joined: Thu Oct 27, 2011 6:11 pm
Location: Vancouver, BC

Postby james.billings » Thu Nov 03, 2011 8:59 pm

You don't have to commit the dynamic tables of course. They will show up on the commit tab, and you can deselect them so they aren't source controlled.
One thing to be wary of is not committing them when they are required by relationships to other objects that you *are* source controlling; as this would cause trouble when another user "Gets Latest" due to dependencies missing.

If these dynamic tables are indeed standalone, then you may want to suggest more complex filtering over on our Uservoice forum where other users can vote up the request. The filtering in there at the moment is basically the same as you'd get in SQL Compare.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby David Atkinson » Thu Nov 03, 2011 9:30 pm

Rob - what sort of RegEx expression were you thinking you'd need to use?

David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests