Re: recommended schema diff tools?

On Fri, Apr 13, 2012 at 12:57 AM, Welty, Richard <rwelty(at)ltionline(dot)com>wrote:

> **
>
> 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.)
>
> thanks,
> richard
>

Richard,

A java command line tool that we have used for years is AGPDIFF -
http://apgdiff.startnet.biz/

Usage is something like this ...
c:> java -jar apgdiff.jar --ignore-start-with pg_old.sql pg_new.sql >
diff.sql

It is PostgreSQL specific. Takes two SQL files and produces the diff.sql,
that we use as the basis of our production upgrade artifacts.

A very useful and basic tool..

HTH
-Damian