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