Hi,
----- Original Message -----
From: "Milorad Poluga" <milorad.poluga@cores.co.yu>
To: <pgsql-general@postgresql.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