Stored Procedure Source Control

Hot Topic

Data driving unit tests but not from database
TFS WorkGroup Edition / 180 day Trial
Creating a user in TFS
License contact - where are they?
Migration story - Beta 3 -> RTM
Team Foundation Server not available on MSDN?
Can merge be run from the api, or do I need to shell out and run command line?
Team Explorer in Visual Studio 2005 RC1 Team Suite
Project level lists
Startup error

VS Team System

Validation & Extraction Rule Parameters
Check In: Operation not performed
Unable to add users to Team Project if using VPN.
Bug Rates Report - Getting very weird report
How to get the DISPLAY NAME rahter than the USER NAME in Assignments for Work Items
How to manage many team projects
Possible to detect use of enum.ToString()?
Another 3200 Error during setup
Identifiers should have correct suffix (CA1710)
Registration Service

Stored Procedure Source Control

Is there any way to implement source control for stored procedures using TFS and Visual Studio 2005 I am looking for the interface that was available under VS 2003 and Visual Source Safe. We would prefer to see the lock icon on the stored procedure itself when you view them under Server Explorer. This prevents anyone editing the sp without checking it out. We want to avoid the current approach of creating a script file and adding it to a database project.

I have looked everywhere, but can't find the solution. I've installed the MSSCCI plug in for SQL Server Management Studio, but you still need to create a text file, and add that to source control manually.

Thanks

Sara Stanford

Answer this question

Stored Procedure Source Control

  • AddinDeveloper

    As far as I know: the SCC features under Server Explorer don't work in VS2005, and creating script files is the best way.

    (I'm going off this thread and this thread -- the design & functionality of VS projects is not our area.)

    You may want to try the new VSTD product when it debuts next week.

  • An_Cala

    Thanks Richard. I'll check the VSDT product. Hopefully if it doesn't provide the functionality it will be added soon to vs2005.

  • Gordon Donald

    I found one artilce related with Source control of stored procedure, this might help you. http://www.dotnetfunda.com/articles/article20.aspx

    Thanks


  • Antonionini

    Article looks great, however, I believe that Team Edition for Database Professionals is the way to go.
  • Stored Procedure Source Control
Answer this question