Re: Schema version control

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema version control
Date: 2011-02-10 23:02:16
Message-ID: ij1qpo$lpd$2@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran wrote on 10.02.2011 23:59:
> The overview:
> You store your schema and data as XML (this is easy to migrate to, because
> it includes a tool that makes the XML from a live database)
> Keep your XML schema files in some RCS.
> When it's time for a new deployment, you run the dbsteward tool against
> the schema XML and it turns it into DDL and DML.
> When it's time for an upgrade, you run the dbsteward tool against two
> schema XML files, and it calculates what has changed and generates the
> appropriate DDL and DML to upgrade.

This very much sounds like Liquibase. Do you happen to know any differences?

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Chambers 2011-02-10 23:14:02 Re: Schema version control
Previous Message Bill Moran 2011-02-10 22:59:30 Re: Schema version control