dbMaintain 1.0.1

dbMaintain 1.0.1 is one of the most marvelous tools which enables automatic roll-out of updates to a relational database.

It brings database scripts into version control just like regular source code and can be used to transparently deploy databases from development to production. DbMaintain automates the part of the deployment which is most difficult to automate, opening the door for fully automated deployments in all stages of development.

You no longer have to keep track of which database updates have been deployed on which database - DbMaintain does this for you. The database itself keeps track of the scripts that have been applied. A checksum is stored for each script that to ensure nothing has changed to the scripts that were already applied.

Updates are performed incrementally: Only what has been changed since the last deployment is applied. Features such as repeatable scripts, postprocessing scripts, multi-database / database user support and support for patches turn DbMaintain into a complete solution for the enterprise.
DbMaintain integrates seamlessly with Unitils, an open source library for writing automated tests. With unitils you can easily test your application's database integration layer while you develop it, relying on DbMaintain for managing the test database.

Major Features:

1. Script organization
   • Incremental and repeatable scripts
   • Postprocessing cripts
   • Multi-database / user support
   • Patches
2. The DBMAINTAIN_SCRIPTS table
3. Error handling
4. Configure and run DbMaintain
   • From the command line
   • Using ant
   • From Java code
5. DbMaintain operations
   • Create a script archive
   • Update the database
   • Mark the database as up-to-date
   • Check script updates
   • Clear the database
   • Clean the database
   • Disable constraints
   • Update sequences
6. Preserve database objects
7. Oracle PL/SQL support