| 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@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
| 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 |