RE: RE: SQL Enterprise Manager Stored Procedures and Subversion

Tanya,

You can check this list for a comparison of source control solutions:

http://better-scm.berlios.de/comparison/comparison.html

Regards,

Andrei.

________________________________

From: Janca, Tanya [mailto:TJanca@justice.gc.ca]
Sent: Tuesday, October 09, 2007 8:18 AM
To: Brad Rhoads
Cc: users
Subject: 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