dbdeploy 3.0 milestone 2 released
Graham Tackley
This is a significant update to dbdeploy. The main features include:
* ability to apply changes direct to database [issue 10]. Note this
change means that, when working in this mode, dbdeploy works out of
the box with any database since it just uses standard sql and jdbc.
It is expected that most users will use dbdeploy this way in the
future, though there are no plans to stop the script generation
support. If you omit "outputfile" dbdeploy will apply the changes
directly to the database.
* user customisation of scripts [issue 17]. dbdeploy now uses
freemarker to generate scripts, and users can specify customised
scripts. See http://code.google.com/p/dbdeploy/wiki/GeneratingAndCustomisingScripts.
Please keep reporting when the bundled scripts are broken though :)
* simplification of deltasets [issue 19]. Instead of deltasets you can
now specify the name of the changelog table. Use different changelog
tables for different deltasets. Note this involves (another) change
to the structure of the changelog table[1]. (Thanks to rhyskeepence
and simon.brunning.)
* support for db2 [issue 11]. (Thanks to David Carlson.)
* support for postgres [issue 26]. (Thanks to tfnico.)
There are also many bug fixes, especially those that made 3.0M1
unusable for oracle users.
You can download this release from
http://code.google.com/p/dbdeploy/downloads/list or from the m2
repository at http://dbdeploy.googlecode.com/svn/m2-repo/repository/.
If you're upgrading from 2.X you should read
http://code.google.com/p/dbdeploy/wiki/UpgradingFromVersionTwo because
3.0 contains *breaking changes* including a need to change your
changelog table.
Your feedback and experiences are welcome. Please raise or comment on
an issue, or send to http://groups.google.com/group/db-deploy-users.
(And yes, I'm working on sorting the stupid amount of spam on that
list. Arrgh.)
Note that this is milestone release, not a final release. To see what
changes are expected before the final release of 3.0, please visit
http://code.google.com/p/dbdeploy/issues/list?q=milestone:Release3.0.
Thanks for all of your support, comments and contributions. Special
thanks to aknauf for his contributions and inspiration.
g
[issue 10] http://code.google.com/p/dbdeploy/issues/detail?id=10
[issue 17] http://code.google.com/p/dbdeploy/issues/detail?id=17
etc
[1] http://code.google.com/p/dbdeploy/wiki/UpgradingFromVersionTwo