On Thu, Apr 12, 2012 at 9:35 PM, Thomas Kellerer <spam_eater@xxxxxxx> wrote:
Welty, Richard wrote on 12.04.2012 16:57:
can anyone recommend an open source tool for diffing schemas?
(it should go without saying that i'm looking for ddl to update
production and QA DBs from development DBs, but i'll say it, just in
case.)
Take the dumps of two schemas in plain format like this:
pg_dump.exe -Fp -U edb -s -n schema1 edb > db.out
pg_dump.exe -Fp -U edb -s -n schema2 edb > db1.out
Now you can use a tool like Kompare [http://www.kde.org/applications/development/kompare/] to get a diff between two schema files and see where there is a change in the schema.
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com
