Re: Schema version control - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Schema version control
Date
Msg-id ij1qpo$lpd$2@dough.gmane.org
Whole thread Raw
In response to Re: Schema version control  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Schema version control
List 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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Schema version control
Next
From: Rob Sargent
Date:
Subject: Re: Schema version control