Re: Version control for databases

On 15 May 2006, at 21:59, Baz wrote:

> Our scheme is somewhat similar to jamie's, with directories full of
> sequential patch scripts (organized by release instead of by date)

Another similar approach, but with some automation, is the perl module
DBIx::Migration:

   http://search.cpan.org/search?query=dbix+migration

Again, it has symmetrical pairs of sql file to apply or revert a change
to the schema. Additionally it adds a table to the db so that the db
can report which version it is at.

Richard

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu May 25 19:08:48 2006