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: 241
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. 
Technorati Tags: MSBuild
© Geeks with Blogs or respective owner
