Using SQL Source Control to Version multiple environments

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

Using SQL Source Control to Version multiple environments

Postby Barry H » Thu Sep 01, 2011 11:44 am

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 H
Posts: 6
Joined: Wed Aug 31, 2011 12:47 pm

Postby Brian Donahue » Mon Sep 05, 2011 2:10 pm

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests