Skip site navigation (1) Skip section navigation (2)

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$ (view raw, whole thread or download thread mbox)
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?


In response to


pgsql-general by date

Next:From: Andy ChambersDate: 2011-02-10 23:14:02
Subject: Re: Schema version control
Previous:From: Bill MoranDate: 2011-02-10 22:59:30
Subject: Re: Schema version control

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group