On Thu, Apr 12, 2012 at 9:35 PM, Thomas Kellerer <spam_ea...@gmx.net> 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 diffbetween two schema files and see where there is a change in the schema. -- Thanks & Regards, Raghu Ram EnterpriseDB: http://www.enterprisedb.com