Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Version Control for stored procedures in VS.NET

Author  Topic 

Daeljan
Starting Member

2 Posts

Posted - 2004-03-23 : 08:23:57
This has me baffled. I am developing on Windows 2000 Server. Locally I have SqlServer, Vss Client & Server, Visual Studio 2003.

Visual Studio 2003 was installed with the option for support for Version Control for Stored Procedures.

I have this option enabled in the Tools/Options/Database Tools/Server Explorer/ menu.

I have added a connection to the database, and I can see the stored procedures, but right clicking around, I see no trace of where I can add them to source control. Any ideas what could be wrong?

Thanks.

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2004-03-23 : 08:39:46
You have to script them out to a db project and then the scripts get added to source safe.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-03-23 : 08:41:06
Read this first:

http://www.nigelrivett.net/SQLServerReleaseControl.htm

Secondly, VS.Net is not necessary for these tasks. You can definitely develop SQL Server procedures without it, and put them under source control without it.
Go to Top of Page

Daeljan
Starting Member

2 Posts

Posted - 2004-03-23 : 09:54:29
Hi,
Thanks, I have discovered the database project in VS.NET:

[url]http://blogs.msdn.com/korbyp/archive/2003/07/03/54046.aspx[/url]

I can see how to add it to VSS now.

Up until now, before the database went live, it was possible to use Visio for everything as I could create the database from scratch each time (it was still under development then, along with the app).
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-03-23 : 18:28:41
And if you actually want your code to be safe, you could consider one of the many alternatives to VSS.

CVS http://www.cvsnt.org & http://www.tortoisecvs.org
Vault http://www.sourcegear.com
Subversion http://subversion.tigris.org/

are a few



Damian
Go to Top of Page
   

- Advertisement -