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.)
You might want to have a look at SQL Workbench/J. It has it's own "SQL command" for doing a diff on schema level. http://www.sql-workbench.net/manual/compare-commands.html The output is a (dbms independent) XML file, but XSLT templates to transform that into SQL are available: http://www.sql-workbench.net/xslt.html The XSTL might need some adjusting for your purposes though. But you should put a controlled way of deploying schema changes into place. Doing a diff of a developer DB isn't really the ideal approach. We are quite happy using Liquibase for this purpose: http://liquibase.org/ Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
