_jesse

I want to use Visual Studio to add my database schema and stored procedures
to source control. I've read that this is possible -- but apparently not in
2005 Standard Edition. (So glad I bought it!)

In which versions of VS 2005 can you:

- add table defs and stored procedures to source control
- create CLR stored procedures


Thank you!


Re: Visual Studio Source Control and SourceSafe VS.NET with SQL Server source control?

Bruno Yu - MSFT

Move the thread from Visual Basic IDE in order to get better and satisfied answers.






Re: Visual Studio Source Control and SourceSafe VS.NET with SQL Server source control?

Richard Berg MSFT

In VS Standard Edition, you can use the Database Project type to hold all of your SQL objects as scripts. However, it does not have many other features. For example, if you need a build process that deploys the scripts onto a server, you'll have to write your own.

VS Team Edition for Database Professionals (aka "DBPro") has many more features. It will examine your existing databases and automatically create scripts for each object. When you and others make changes, it can do a Schema Compare and refactor your scripts appropriately. Lots more info is available on MSDN and in their forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=725&SiteID=1

Both project types can be placed under source control. (The source control system doesn't really care what type the files are.)




Re: Visual Studio Source Control and SourceSafe VS.NET with SQL Server source control?

_jesse

Thanks for the reply, Richard. The problem I seem to be having is that I can't find the Database Project option in Visual Studio 2005 Standard. When I go to File -> Add -> New Project, "Database Project" is not offered as an option. Is it something I need to download from somewhere

I've been told that the Database Project type is only available in 2005 Professional, but I can't seem to get confirmation of that (without buying it first).

Thanks!





Re: Visual Studio Source Control and SourceSafe VS.NET with SQL Server source control?

Richard Berg MSFT

You may be right. I can't find much info on Standard vs Professional. This page seems to indicate it's available in Pro. I'd talk to a MS sales rep before buying anything.