Russ Brown wrote on 09.06.2005 23:12:
> Currently we just store a dump of the data structure. However, what I
> think is really needed is a specialist diff tool which works out the
> commands needed to move from one schema to another. That would be
> *extremely* useful, but would also probably require a separate
> implementation for each database backend.
>
I have just implemented such a feature in my SQL Tool. It will output the
difference between two schemas as an XML file which in turn can be
transformed in the correct SQL scripts.
The tool can be downloaded from http://www.sql-workbench.net
(You are looking for the WbDiff command)
An (very basic) XSLT to transform the XML output into a PG SQL script is
also available there (look in the XSLT section). You might want to use the
latest development build because I have done some tweaks and enhancements
to the output.
This is a first implementation (and mainly tested with Oracle). If you have
feedback or suggestions on how to improve it, feel free to contact me at:
support (at) sql (dash) workbench (dot) net
Best regards
Thomas