Performing a clean database build with MSBuild part 2

Posted by Robert May on Geeks with Blogs See other posts from Geeks with Blogs or by Robert May
Published on Fri, 31 Dec 2010 17:41:57 GMT Indexed on 2010/12/31 17:54 UTC
Read the original article Hit count: 268

Filed under:

In part 1, I showed a complicated mechanism for performing a clean database build.

There’s an easier way.  The easier way is to use the msbuild extension tasks out on codeplex.  While you’ll still need to forcibly take the database offline (ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE), the other msbuild tasks more easily allow you to create and delete the database.  Eventually, I’ll post an example. Smile

Technorati Tags:

© Geeks with Blogs or respective owner