Re: How to compare the schemas ?

Hi,

----- Original Message -----
From: "Milorad Poluga" <milorad(dot)poluga(at)cores(dot)co(dot)yu>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, June 22, 2005 1:36 PM
Subject: [GENERAL] How to compare the schemas ?

>Hi everyone,
>
>I am looking for the best way to compare the schemas of two databases with
the very similar structure.
>One (certainly not the best options) is to do something like this:
>
>pg_dump ... DB1 > PG_SCHEMA1
>pg_dump ... DB2 > PG_SCHEMA2
>diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt

One way is using DBTools Manager (Windows application) to compare the
database. There is a wizard for this purpose which you can use to compare
the entire database and generate the SQL/DDL statements to update the target
database. After the wizard finishes it generates a tree of the changes which
can show you all the objects that will be updated.

PS: Although there is a free version of DBTools Manager, the Compare Wizard
is only available in the commercial edition.

Crercio