Re: How to compare the schemas ?

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