|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL stored proc source controlHi,
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 Vi (V*@discussions.microsoft.com) writes:
> I have a Visual SourceSafe 2005 server, another server with SQL Server In SQL Server Management Studio there is SourceSafe integration. Note> 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. 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 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. |
|||||||||||||||||||||||