From: | Frank Kurzawa <fkurzawa(at)topazsoftware(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Comparing database schema's |
Date: | 2004-08-02 22:04:07 |
Message-ID: | 1091484247.5419.93.camel@zaza.aus.topazsoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
How are people doing automated comparisons of schemas in different databases?
E.g. we have a dev database, a beta database, and a production database. We
need to insure that changes in schema are propagated properly during the
development and deployment process.
I've experimented some with 'pg_dump -s' to do this: Do a schema dump on the two
databases and a diff. But due to myriad small differences (order of creation
of tables, constraints, etc.) it is very difficult to get a usable diff without
engaging in massive massage of the dump output, including dumping a table at a time.
I found a reference to a schema comparison tool in the mailing list archives, but
it appears to be far out of date and not currently supported.
Regards,
Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-08-02 22:19:22 | Re: Comparing database schema's |
Previous Message | Si Chen | 2004-08-02 18:26:35 | inserting multiple rows |