octalforty Wizardby

This is octalforty Wizardby, a powerful yet easy to use database continuous integration & schema migration framework primarily targeting .NET. The latest release is Alpha 3.

What Is Wizardby?

Managing changes to a database schema has been one of the most complex tasks for a team of developers. Most have relied on storing platform-specific DDL in revision control, manually applying them for each deployment on each and every database instance.

Downsides of this approach are obvious:

All change scripts must be written manually, with all the duplication this incurs
Information about applied scripts has to be tracked manually as well
Rollbacks are impossible unless rollback scripts are written -- manually, of course
Manual transaction management, which can easily leave database in an inconsistent state

Wizardby alleviates all these problems.

Single platform-independent script, which is the authoritative source for the database schema. You don't have to worry about precise syntax of alter table now
Wizardby automatically keeps track of applied migrations. Applying all changes to a database becomes as easy as executing wizardby upgrade on the command line; migrate to specific version with wizardby migrate 20090430.
Rollback scripts are generated completely automatically
Transactions are managed automatically as well; your databases will always be in a consistent state
Wizardby can easily be integrated into your build and deployment process or can be used inside your application

Why Versioning My Database Is Important?

For a comprehensive discussion of this topic, read a series of posts by K. Scott Allen:

And see what users are saying.

Features

octalforty Wizardby provides a simple and DRY DSL for writing migrations in database-independent manner.

Database-independent DSL for writing migrations
Supports collective development
Automatic database deployment
Automatic schema version tracking
Automatic generation of downgrade scripts
Schema reverse engineering
Supports several database platforms
Supports Native SQL Scripts
Continuous Integration-ready
Frictionless development flow
Powerful Developer API

Getting Started

Downloading

Current version of octalforty Wizardby can be downloaded here. Both binaries and source code distributions available. You might also browse Subversion repository or check out source altogether.

Documentation

Refer to the Getting Started page for information on what is a migration and how Wizardby can help you. See MDL Reference for information on how to write migration definitions, and Wizardby In Action to see how to use Wizardby in real-life development.

See Supported DB Platforms page for a list of supported DB platforms: