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

RE: Database Development w/ SVN

From: Tony Sweeney <tsweeney_at_omnifone.com>
Date: Fri, 13 Nov 2009 09:52:52 -0000

> -----Original Message-----
> From: Daniel Becroft [mailto:djcbecroft_at_gmail.com]
> Sent: 12 November 2009 22:23
> To: Tony Sweeney
> Cc: Felix Gilcher; Thomas Harold; users_at_subversion.tigris.org
> Subject: Re: Database Development w/ SVN
>
> On Thu, Nov 12, 2009 at 9:53 PM, Tony Sweeney
> <tsweeney_at_omnifone.com> wrote:
> >
> >
> >> -----Original Message-----
> >> From: Felix Gilcher [mailto:felix.gilcher_at_bitextender.com]
> >> Sent: 12 November 2009 09:19
> >> To: Thomas Harold
> >> Cc: Daniel Becroft; users_at_subversion.tigris.org
> >> Subject: Re: Database Development w/ SVN
> >>
> >
> > There is an open source tool called 'dbdeploy' that we use
> for the same task.  It's not especially branch-aware, but it
> gets the job done for what we need.
> >
> > http://dbdeploy.com/
>
> Thanks, Tony, that tool looks interesting. Unfortunately, it
> looks like it's SQL only.
>
> With this concept on an SQL system, though, do you try and
> minimize the number of schema updates (as opposed to data
> updates) that are made? Especially with regards to new
> indexes on existing tables, would you create two different
> changes? Or determine all index changes required on such a
> table, and apply them at once?

We group our changes functionally. We use JIRA for defect/improvement tracking, so the mapping for us tends to be:

One JIRA issue -> one delta script

The actual contents of a delta can include multiple drop/create/alter table/index statements, critical core metadata fixes, whatever is needed to fix the JIRA issue. For the most part, however, ours are DDL or application metadata only; we handle application data (as opposed to metadata, if that makes sense) separately.

Tony.
>
> Regards,
> Daniel B.
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit
> http://www.messagelabs.com/email
> ______________________________________________________________________
>

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=1065&dsMessageId=2417480

To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_subversion.tigris.org].
Received on 2009-11-13 10:53:32 CET

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.