CODEWITHSUNDEEP
sqldatabasecontinuous-integrationcruisecontrol.net
Eric Tarasoff
Eric Tarasoff

Reputation: 611

Alternatives to Tarantino for database Continuous Integration (CI)?

We're currently using VincentVega (now rolled into Tarantino) for our database CI. We're using CruiseControl.Net for our web app (C# using TFS).

VincentVega has worked out relatively well since it's very explicity and handles the two scenarios of create and update (while preserving existing data) equally well. I'm looking into upgrading to Tarantino, but I'd like to know if anyone might suggest some alternatives I should look into? Tools like SQL Compare that "automagically" produce delta scripts are out of the question, unfortunately, since our database is highly normalized with over 500 tables.

Thanks

Eric Tarasoff

Upvotes: 5

Views: 2343

Answers (3)

David Atkinson
David Atkinson

Reputation: 5899

I think it might be of interest to post another answer since Redgate now has a new offering, ReadyRoll, that satisfies your key concerns.

  • "it [SQL Compare] just doesn't put together a synch script correctly"

Yes, diffing tools can sometimes get the script wrong. Often it's not that the script doesn't work, but it doesn't apply the change in the desired way. ReadyRoll's best-of-both-worlds approach uses SQL Compare under the hood to create each migration script, but crucially it allows the developer to customize the script afterwards.

  • "RoundHousE and tools like it already operate in a model similar to what we're doing now"

ReadyRoll's approach is, like RoundHousE, migrations-based, managing the upgrade process by running a series of consecutive scripts. This tool was built in recognition that many development teams prefer working this way.

  • "One last reason for choosing RoundHousE: Chuck Norris"

I will have to concede defeat on this point...

Upvotes: 2

dthrasher
dthrasher

Reputation: 41772

There's a similar tool by Paul Stovell and friends called DbUp.

One notable difference between Tarantino and DbUp is that while Tarantino is typically called from a build script (like Nant or msbuild), DbUp has .NET classes you use within your application. This potentially allows for better fallback handling in case a script doesn't go as planned.

http://code.google.com/p/dbup/

Here's the original announcement of DbUp from Paul Stovell's blog: http://www.paulstovell.com/dbup

Upvotes: 3

Ryan Anderson
Ryan Anderson

Reputation: 947

There is also another project which may be worth looking at by Rob Reynolds; RoundHousE

http://code.google.com/p/roundhouse/

The wiki is at https://github.com/chucknorris/roundhouse/wiki

Upvotes: 5

Related Questions