dbmstools

Major improvements in this version include: proper
support for UTF-8 (Unicode) and ISO-8859-1 (Latin
1) character encodings; basic support for the
SQLite DBMS; and an improved Jython Ant task
supplied as a single standalone jar file
(containing Jython, the Ant task, and all the
dbmstools scripts). The version of Jython supplied
has been updated to 2.2.1.

The major change is support for runtime variables. This allows generation of schema variants based on any conditions you choose, and insertion of variables in documentation for any element. Other changes include explicit support for column defaults and auto-increment columns, 'tiny' and 'boolean' data types, as well as sequences on the Hypersonic DBMS. MySQL support has been improved, particularly in generating upgrade scripts with deltaddl. There were also small bugfixes and improvements.

This version adds the ability to control the inclusion of any item in
the schema, based on variables supplied at runtime. This allows you
to generate schema variants based on any conditions you choose,
which is particularly useful for things like including different indexes
on your master and slave schemas for replication. There have also
been a couple of other minor enhancements and bugfixes.

This version adds explicit support for column
defaults and auto-increment columns, "tiny" and
"boolean" data types, as well as sequences on the
Hypersonic DBMS. MySQL support has been improved,
particularly in generating upgrade scripts with
deltaddl. The usual slew of small bugfixes and
improvements were made.

This version improves the db2sql script, which
exports data from a database. New output formats
are now supported: text, CSV, TSV, and XML. The
script runs much faster. Memory use when exporting
large tables on Postgres has been dramatically
reduced. A few other minor enhancements have been
made.