Re: recommended schema diff tools?

On Thu, Apr 12, 2012 at 9:35 PM, Thomas Kellerer <spam_eater(at)gmx(dot)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