Red Gate forums :: View topic - Recommended setup for Red-Gate SQL 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 3
SQL Source Control 3 forum

Recommended setup for Red-Gate SQL Source Control

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mjharper



Joined: 27 Oct 2009
Posts: 7

PostPosted: Mon May 13, 2013 3:58 pm    Post subject: Recommended setup for Red-Gate SQL Source Control Reply with quote

I have my databases in TFS using Red-Gates SQL Source Control Ė but Iím not convinced Iím using it in the best way.

My setup is that we have one ďnearlyĒ core database that gets replicated for each client. This core is probably 90% of the objects. There is then the 10% that are client specific. For example there may be a View that filters on different names for different clients, there is a user that is unique for each client database (but linked to a standard role).

At the moment I have each client database linked to the same TFS project (in dedicated model). If there is a bug found I fix it in one client database and check-in. Then I get latest for all of the other client databases. I have to be careful when getting latest not to get objects that are different for each client (there is a generic version of each object in TFS which I use initially, but once Iíve configured the database for the client I donít want to overwrite the database version with the one from TFS). I also have to be careful when committing changes as I donít want to overwrite the generic version with the client specific version.

Iím sure this kind of setup isnít unique Ė how are other people handling this? Any advice is much appreciated. (Iíve posted this question on http://ask.sqlservercentral.com as well)
_________________
Matt
Back to top
View user's profile Send private message
james.billings



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

PostPosted: Wed May 15, 2013 5:42 pm    Post subject: Reply with quote

I see you've had one reply over on SSC- I couldn't tell from your original post if you do have just a subset of the database currently source controlled right now though?

One other option we came up with is to look at filters- you could add a filter to each customer database to effectively exclude all the customer-specific objects. You can read about filters here. This means you can safely get/commit objects and know they are just the shared ones (assuming you set it up correctly)

The downside of this of course, is setting up the filters requires some initial configuration (and possibly ongoing maintenance). Also, if there are dependencies between objects you're changing and the customer-specific ones, you may find that customer specific objects still get committed. You can turn off dependencies by editing the options

Hope that helps!
Back to top
View user's profile Send private message
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