Manages the deployment of numbered change scripts to a SQL database, using a simple table in the database to track applied changes.

Read the getting started guide for an introduction to what dbdeploy can do.

More details can be found at http://www.dbdeploy.com.

News

18 Oct 2009: 3.0M2 released!

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.
• user customisation of scripts ( issue 17 ). dbdeploy now uses freemarker to generate scripts, and users can specify customised scripts. See 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. (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 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.