The Tarantino Project - Database Change Management

The Tarantino Project is a very simple to use database change management system that uses an application or NAnt deployment tasks to do so. I've been checking out Tarantino for about a week and I just started using it today and wanted to share my experience with how easy it is to use.

To use Tarantino, all you have to do is follow a couple of conventions.

You create a folder for a particular database. Then you have two folders under that, Create and Update.

dbFolder

You name each sql task you want it to do in ORDER, starting with 0001-name.sql.

updatefolder

Then you set up a task that points to that top level folder:

<manageSqlDatabase
    scriptDirectory="db"
    action="Update"
    server="(local)"
    integratedAuthentication="true"
    database="test"
    />

The actions you can do include Create, Update, Drop, and Rebuild.

Push the values for these task properties into their own properties or external to the NAnt file.

You also need to drop the required files in your NAnt directory (these are a little different than the documentation, consider this the updated list).

  • log4net.dll
  • Microsoft.SqlServer.BatchParser.dll
  • Microsoft.SqlServer.ConnectionInfo.dll
  • Microsoft.SqlServer.Replication.dll
  • Microsoft.SqlServer.Smo.dll
  • Nhibernate.dll
  • StructureMap.dll
  • Tarantino.Core.dll
  • Tarantino.DatabaseManager.Tasks.dll
  • Tarantino.Infrastructure.dll

There is a more detailed explanation here: http://code.google.com/p/tarantino/wiki/DatabaseChangeManagement

Print | posted @ Tuesday, March 24, 2009 5:56 AM

Comments on this entry:

Gravatar # Any info on using this with an existing db?
by Luke at 6/4/2009 6:53 PM

We'd like to start using this, but it seems rigged more for new/from scratch projects. Any info on using it with a new db?
Gravatar # re: The Tarantino Project - Database Change Management
by Robz at 6/5/2009 5:38 PM

@Luke: We are using it with new (greenfield) and existing (brownfield) development. We are applying it to a very specific area (DDL and DML changes).
Comments have been closed on this topic.