John wrote on 28.09.2009 18:24:
Thanks that will help. After all this time I'm surprized that someone hasn't provide an easy way to get this done. It's has to be every developers problem.
Have a look at my SQL Workbench. It has a built-in command to generate a diff between two databases. The output is an XML file that can easily be transformed into the approriate SQL scripts (a sample XSLT for Postgres is available) http://www.sql-workbench.net Description of the WbSchemaDiff command: http://www.sql-workbench.net/manual/wb-commands.html#command-schema-diff Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
