Visual Source Safe & SQL Server

microsoft.public.sqlserver.programming

3 Nov 2005 5:36 PM

marcmc

Hey All,

I have spent the day running around the web reading about the above thread
title.
I have used SQL and VSS before without any problem.

However, in that organisation we had a dev-->> Rel & Tst environment. In mu
current role, we have a dev -->> QualitityControl1 -->> Quality Assurance2
-->> Release environment.

I have a whiteprint of how we are going to achieve this and although it
seems to work quite well, it seemed the only option. Therefore, I got an
idea, stuck with it and it turned out okay. Here's the flow:

add production versions.
'chk out' into dev the version you are working on.
'chk in' into dev when finished
'Move' version to QualitityControl1
if production bug comes up, move back to dev and apply fix and move through
envs again.

Anybody any other ideas?