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) ??