We were running Tarantino 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?
We were running Tarantino 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.
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.