Re: sync structures

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
XMLfile 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