Home All Groups Group Topic Archive Search About

SQL stored proc source control

Author
13 Feb 2006 5:15 AM
Vi
Hi,
I have a Visual SourceSafe 2005 server, another server with SQL Server 2000
and I'm using Visual Studio 2005 on my workstation.

I want to be able to add SQL stored procedures to VSS, and to be able to
manage everything from Visual Studio 2005 on my workstation.

I can't find any documentation that would describe such a setup. The only
thing I found was http://support.microsoft.com/?kbid=818368 , but it talks
about VSS 6 and Visual Studio .NET and it doesn't exactly match:
1) There's no Netsetup.exe anywhere on the VSS server
2) There's no "Server Components --> Stored Procedure Version Control" in
Visual Studio 2005. There's nothing related to source control in VS.NET 2005.

I'd appreciate any help,
Thanks

Author
13 Feb 2006 11:11 PM
Erland Sommarskog
Vi (V*@discussions.microsoft.com) writes:
> I have a Visual SourceSafe 2005 server, another server with SQL Server
> 2000 and I'm using Visual Studio 2005 on my workstation.
>
> I want to be able to add SQL stored procedures to VSS, and to be able to
> manage everything from Visual Studio 2005 on my workstation.
>
> I can't find any documentation that would describe such a setup. The
> only thing I found was http://support.microsoft.com/?kbid=818368 , but
> it talks about VSS 6 and Visual Studio .NET and it doesn't exactly
> match: 1) There's no Netsetup.exe anywhere on the VSS server 2) There's
> no "Server Components --> Stored Procedure Version Control" in Visual
> Studio 2005. There's nothing related to source control in VS.NET 2005.

In SQL Server Management Studio there is SourceSafe integration. Note
that it works with files. (Or least I believe so.) What was in VS6 and
Visual Interdev was seriously flawed, as SQL Server checked in/out
the files.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Author
14 Feb 2006 2:39 PM
yoni
Hello Vi,
this doesnt answer your question directly, frankly i have problems
doing that myslef, but check out this tool, it does exactly what you
are looking for:

http://www.nobhillsoft.com/randolph.aspx

It scans your databases for you, and if you choose it pushes
automatically all your changes to SourceSafe. the bottom line is, you
will have everything (not only TSQL code but full schema... tables,
indexes, etc...) in your SourceSafe, no matter what way you prefer to
work.

AddThis Social Bookmark Button