RE: SQL Enterprise Manager Stored Procedures and Subversion

Thanks Brad, but that's pretty much the same solution that Visual Source
Safe gives us, and we are already using it, so we'll probably stick to
it.... Thanks anyway!

________________________________

From: Brad Rhoads [mailto:bdrhoa@gmail.com]
Sent: October 5, 2007 4:12 PM
To: Janca, Tanya
Cc: users
Subject: Re: SQL Enterprise Manager Stored Procedures and Subversion

Hi Tanya,

With subversion, you'll have a working copy of your repository in a
directory on your machine. The scripts will all be in there as simple
text files. Open a file from Enterprise Manager , make changes ,
execute, save the file.

Of course you do need to commit your changes to the repository. But
that's trivial, especially with TortoiseSVN
(http://tortoisesvn.tigris.org/).

-Brad

On 10/5/07, Janca, Tanya <TJanca@justice.gc.ca> wrote:

        Hello
         
        Thanks for writing me back! So, if I open them from the
repository, can I edit them and then run them from there? If I have
exported the scripts, don't I need to copy them back in each time to
test my changes? Can I run them from the repository? I wasn't under
the impression that I could...
         
        Tanya

________________________________

        From: Brad Rhoads [mailto:bdrhoa@gmail.com]
        Sent: October 5, 2007 3:15 PM
        To: Janca, Tanya
        Cc: users@subversion.tigris.org
        Subject: Re: SQL Enterprise Manager Stored Procedures and
Subversion
        
        
        
        Once you've exported the scripts for the first time and added
them to you're repository, the only discipline required is open the file
from your repository instead of from the database. You can still use
Enterprise Manager essentially the same way you do today.
        
        
        On 10/5/07, Janca, Tanya <TJanca@justice.gc.ca> wrote:

                Hello all,

                We are using Enterprise Manager to edit our stored
procedures. We are starting a new project and considering all of our
source control options. Is there a way to integrate subversion into MS
SQL Server 7 to edit our stored procedures. We currently use Enterprise
Manager for editing... We do not want to have to export our scripts one
by one, check them into a source control program, and then discipline
ourselves to check them out, edit them in our database, test them,
export and copy into our source control text files, then check them in
again. It's quite tedious, and could easily end up creating a mess.
=3D20 =3D20 The = only fully-integrated option we have come up with so
far is to get .Net 2005 TEAM Edition and MS Visual Source Safe, then
editing our stored procedures with the .Net. The two apps fully
integrate for stored procedures, but only the team edition, not the pro
edition that we already own licenses to... An upgrade with all new
licenses is expensive. We are looking for a more economical solution. Is
subversion it?

                Thanks

                Tanya

        ---------------------------
        www.maf.org/rhoads
        www.ontherhoads.org

-- 
---------------------------
www.maf.org/rhoads
www.ontherhoads.org