Re: Schema migration tools?

From: "Jonathan Bond-Caron" <jbondc(at)gmail(dot)com>
To: "'Kerri Reno'" <kreno(at)yumaed(dot)org>,"'Christophe'" <xof(at)thebuild(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Schema migration tools?
Date: 2008-04-22 20:44:20
Message-ID: 003201c8a4b9$a55fe790$f01fb6b0$@com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general

If you’re looking for a PHP solution, there’s:

http://ezcomponents.org/docs/api/latest/introduction_DatabaseSchema.html

It’s very limited but works for simple schemas, I begun extending it to
support more rigorously SQL-92 schema information (will be released BSD
license at openmv.com).

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Kerri Reno
Sent: April 22, 2008 8:44 AM
To: Christophe
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Schema migration tools?

Christophe -

We use LiquiBase: http://www.liquibase.org/home

We don't use it quite the same as what you're proposing, but I think you
could use it that way. When we found it, we did 'Generate Changelog' to
start, then made new changes to the ChangeLog, and applied it to each
database as needed. It has really helped us, because we were forgetting to
apply the changes to the production database that were needed.

Hope this helps!
Kerri

On 4/21/08, Christophe <xof(at)thebuild(dot)com> wrote:

Greetings,

We have the traditional three servers:

dev --> staging --> production

each with a PostgreSQL instance and the same schema, at least over time.
Right now, we handle schema migration (updating the schema for new releases)
by manually-created scripts that apply the changes to staging and
production.

I'd like a tool that would automatically create these scripts, and I
wondered if anything like this existed. The theory would be that it would
consider two databases a and b, and produce the appropriate script to change
b's schema to match a.

Does anything like this exist? If not, I might have a new project...

Thanks!
-- Christophe

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Yuma Educational Computer Consortium
Compass Development Team
Kerri Reno
kreno(at)yumaed(dot)org (928) 502-4240
.·:*¨¨*:·. .·:*¨¨*:·. .·:*¨¨*:·.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2008-04-22 20:45:39 Re: How to modify ENUM datatypes?
Previous Message Scott Marlowe 2008-04-22 20:38:29 Re: Rapidly decaying performance repopulating a large table