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

Re: Version control of Databases

From: erymuzuan <erymuzuan_at_gmail.com>
Date: 2005-06-12 14:30:44 CEST

Yeah you're right, it's not as simple as it seem, they are only a few
pointers out there , namely the agile database group. make popular by
ThoughWorks guys , such as Martin Fowler.

We're working on the same thing , but in our case , the primary
database is MSSQL Server. The major problems is recognizing which
objects needed to in version control, properly mapping the
dependencies between objects, schema and test data, Test data is
particularly poses it own set of challenges, cause it also involves
the migration script. We're using a set of tools, namely NAnt and
PsTools, as well as SQL DMO objects.

Then they're thing like the "release stage", bronze, silver or gold,
and how this release are propagated into higher level, then how to
rebuild the gold and copy them across developers machine.

I'm writing this on my blog at
http://www.ivirtualsb.com/cs/blogs/erymuzuan, it's a work in progress.

On 6/12/05, Russ Brown <pickscrape@gmail.com> wrote:
> Gabor Szabo wrote:
> > On Thu, 9 Jun 2005, Frank Gruman wrote:
> >
> >> Just as a side note - I see this discussion ran around for a while on
> >> this board before. Maybe following the thread will help you find some
> >> answers.
> >>
> >> http://svn.haxx.se/users/archive-2004-05/1453.shtml
> >>
> >
> > Thanks for all the responses.
> >
>
> I'm currently involved with a thread on the PostgreSQL mailing list on
> this very subject, where we've gone into quite a bit of detail about the
> nuances of the problem (it's not as simple as it might first appear to
> be). I'm actually considering starting up a project to solve it in a
> comprehensive manner. You can read more on my blog, which also contains
> a link to the pgsql thread:
>
> http://pickscrape.blogspot.com/
>
> Thanks.
>
> --
>
> Russ.
>
> ---------------------------------------------------------------------
> 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 Sun Jun 12 14:32:49 2005

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

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.