Friday, February 4, 2011

DBMaintain

http://dbmaintain.sourceforge.net

This thing seems very useful at applying incremental patches to a (multiple) DB.

Concepts:

an incremental script can be executed only once, unless you specify fromScratch - which destroys the DB and recreates it again.

repeatableScripts can be executed as many times as you want

you can pack scripts in a jar (ant createScriptArchive).

supports multiple databases, using @ you can switch

supports out-of-sequence scripts, using #patch

.... to be continued ....

No comments: