Fervent Coder

Coding Towards Utopia...by Rob Reynolds
posts - 276 , comments - 431 , trackbacks - 0

My Links


Rob Reynolds

Subscribe to Fervent Coder RSS
Subscribe to Fervent Coder by Email

About Me

I manage several open source projects. Need...
   ...package management for Windows?
   ...automated builds?
   ...database change management (migrations)?
   ...your application to check email?
   ...a monitoring utility?

I also write for

Like what you are reading? Want to buy me a cup of coffee?
PayPal - The safer, easier way to pay online!


Post Categories


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.


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


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


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 on Tuesday, March 24, 2009 5:56 AM | Filed Under [ Code ]



# Any info on using this with an existing db?

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?
6/4/2009 6:53 PM | Luke

# re: The Tarantino Project - Database Change Management

@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).
6/5/2009 5:38 PM | Robz
Comments have been closed on this topic.

Powered by: