|
|
|
date: Fri, 10 Feb 2006 07:22:28 -0800,
group: microsoft.public.vsnet.vss
back
Re: Stored Procedure Versioning with VSS 2005 and SQL Server 2000
Hi Alin,
Thank you for your anwser.
On my mind, I thought there I could check the stored procedure directly in
the database. Just when I was testing your solution, I could understand that
to use source control with stored procedures I need to change the way to use
it.
I will need to have each stored procedures in a script, and add ecah one in
a Database Project. When I need to change a stored procedure, I will need
check the script. As VS Database Project is ntegrated with the database, I
just need execute the script to update the stored procedure in the database.
Emerson Zuccherato
"Alin Constantin [MSFT]" wrote:
> Hi Emerson,
>
> I think in VisualStudio 2005 you should simply create a Database Project
> (under File/New/Project...OtherProjectTypes/Database/DatabaseProject),
> and add your sql scripts as files in that project. Then you can add the
> project to SourceSafe like any other project types or solutions (using
> File/SourceControl/AddSolutionToSourceControl menus). You may need to select
> VSS as the active source control provider first (from
> Tools/Options/SourceControl/Plug-ins page).
> I guess more information about stored procedures & source control can also
> be found by posting the question in SQL forums.
> --
> Alin Constantin
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Emerson Zuccherato" wrote in message
> news:25402208-A914-471F-A886-0ACCD3D2329A@microsoft.com...
> > The Article ID 818368 explain how to add Microsoft SQL Server 2000 Stored
> > Procedures to Visual SourceSafe (VSS) by using the Source Control feature
> > in
> > Microsoft Visual Studio .NET.
> >
> > I would like to know how can I do the same with MS Visual Studio 2005. Can
> > you help me ?
> >
> >
> > Thanks,
> >
> > Emerson Zuccherato
> >
>
>
>
date: Mon, 13 Feb 2006 05:57:24 -0800
author: KareenBr
|
|
