Red Gate forums :: View topic - Using SQL Source Control to Version multiple environments
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

Using SQL Source Control to Version multiple environments

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



Joined: 31 Aug 2011
Posts: 6

PostPosted: Thu Sep 01, 2011 12:44 pm    Post subject: Using SQL Source Control to Version multiple environments Reply with quote

Hi All,

I wonder if anyone can help, I work within a small team of developers and we are just looking at implementing the SQL Source Control tool and have hit a couple of stumbling blocks.

What we are trying to do is version both of our environments; Live, PreLive which span circa 14 servers and 100+ databases. We started to add a couple of servers which was fine, the problem came when one of the other developers tried to view the DBs that had been checked in.

The only way we can see to do this is for each developer to create a link to each of the DB's (which could take a while). Is there anyway to automate this or is there another solution? Can developers share the LinkedDatabases.xml file or can this be deployed to a central location and you redirect SSC to that file?

We would then link a sandbox instance to SSC to grab a copy of live and then use SQL Compare Pro to release to PreLive for UAT and then SC Pro again between PreLive and Live for the final release on the source control versions and then SC Pro between the Live source controlled version and the Live DB. Is this the correct way to achieve this? Is there a best practice to follow?

Is anyone else source controlling all environments in this way (or any other) ??

Barry
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Sep 05, 2011 3:10 pm    Post subject: Reply with quote

Hi Barry,

As far as I can tell, the dedicated source control model should suit you. Far as I know all you have to do to get the latest database to your developer's local SQL Server is to create a new database, link it to source control, and get latest.

If this causes any problems, please let me know.
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