We were running Tarantino (http://code.google.com/p/tarantino/wiki/DatabaseChangeManagement) in a Nant build script but we're getting some new hardware and using the opportunity to upgrade to SQL Server 2008. Unfortunately Tarantino won't work with SQL 2K8 so I'm looking for an alternative.
Any ideas?
Migrator.net is the tool I use with SQL 2008. It also has nant script capability. I suggest using the trunk version, rather than the 0.7 release as it's had some good, as yet unreleased changes.
This roundup has other options. And there are few other similar questions here.
There are quite a few really good tools - some require adoption of a database change management process (like DBGhost), while others are less restrictive, but require more work (and efforts) on your side, e.g. Red-Gate's SQL Packager, which allows you to package your database creation and change scripts into .NET projects and/or stand-alone EXE files.
Cheers, Marc
You might try this other question or this article it links to.
Edit: Sorry! I totally missed the "SQL Server 2008" part of the question. I'm not sure what the status of those products is with respect to the new version. But at least you'll have some other choices....
I believe Tarantino has been fixed now to work with SQL2008 as of March 2009
Try the latest version of Tarantino from SVN, it works with SQL Server 2008. Unfortunately, they have an outdated release published in Downloads section.