Re: How to compare the schemas ?
От | DBTools Software |
---|---|
Тема | Re: How to compare the schemas ? |
Дата | |
Msg-id | 002001c5780f$c3716bc0$04c6a8c0@ntdevel обсуждение исходный текст |
Ответ на | How to compare the schemas ? (Milorad Poluga <milorad.poluga@cores.co.yu>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: