Red Gate forums :: View topic - Choosing which Tables to add to source control
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Choosing which Tables to add to source control

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
robnikkel



Joined: 27 Oct 2011
Posts: 4
Location: Vancouver, BC

PostPosted: Thu Oct 27, 2011 7:16 pm    Post subject: Choosing which Tables to add to source control Reply with quote

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?

Thanks,

Rob
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Mon Oct 31, 2011 11:50 am    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
robnikkel



Joined: 27 Oct 2011
Posts: 4
Location: Vancouver, BC

PostPosted: Mon Oct 31, 2011 3:45 pm    Post subject: Reply with quote

Eddie,

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.

Regards,

Rob
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu Nov 03, 2011 9:59 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Thu Nov 03, 2011 10:30 pm    Post subject: Reply with quote

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

David
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group