[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

RE: Source Control for Database Aspect

From: Glenn McAllister <gmcallister_at_sapient.com>
Date: 2005-07-21 15:38:18 CEST

First off, start using scripts to maintain your database if you aren't
already. It's vastly easier to determine who made what change to a
stored proc if all of your source is text.

The problem you are having is that AnkhSVN doesn't (or didn't a while
back, I haven't used it recently) know how to deal with database
projects, since it's not a "standard" C# or VB project. It has the same
problem with SQL Server Report projects. There is absolutely nothing in
Subversion preventing you from keeping your database scripts in the
repository.

I'd suggest taking this issue up with the AnkhSVN developers on their
mailing list.

Glenn McAllister
Sr. Associate Technology, Canada | Sapient

-----Original Message-----
From: Albie Janse van Rensburg [mailto:albie.jvr@gmail.com]
Sent: Thursday, July 21, 2005 5:51 AM
To: users@subversion.tigris.org
Subject: Source Control for Database Aspect

Hi all

I am implementing Subversion for a .Net project at work, and it's great
to be able to use plug-ins like AnkhSVN to get Subversion integrated
with Visual Studio. However, like most software project above the
"Hello World" level, there is a database aspect to our development. We
are using Microsoft SQL Server 2000, and a large part of the project's
business logic lies in stored procedures and metadata that populate
elements in the project. It is necessary to bring the database aspect
into version control, as older versions of the .Net source are often
incompatible with different versions of the database.

Is there any way to accomplish this level of source control using
Subversion? I am also very interested to know whether there are any
Subversion plugins available that would work with SQL Server - it has
some method by which Visual Source Safe (ew...) can integrate, so it
seems natural to assume that third party developers should be able to do

something similar.

Any hints, suggestions or flames (I did mention VSS. Argh! Again!) are
welcome.

Albie

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Jul 21 15:40:10 2005

This is an archived mail posted to the Subversion Users mailing list.