visual-studio-2010 - 使用 MSBuild 和 CruiseControl .NET 构建和部署 VS2010 数据库项目

Question

我几乎有一个 NAnt 脚本可以构建和部署 VS2010 数据库项目，但有一个错误阻碍了我:

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.TSqlTasks.targets(56,5): error MSB4062: The "SqlBuildTask" task could not be loaded from the assembly Microsoft.Data.Schema.Tasks.Sql, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. Could not load file or assembly 'Microsoft.Data.Schema.Tasks.Sql, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Confirm that the <UsingTask> declaration is correct, that the assembly and all its dependencies are available, and that the task contains a public class that implements Microsoft.Build.Framework.ITask. [xxx]
Failed to start MSBuild.
External Program Failed: C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\msbuild.exe (return code was 1)

我可以看到 Microsoft.Data.Schema程序集不在构建服务器上的 MSIL GAC 中 - 如果没有在构建服务器上安装 VS2010 的全运费，是否有任何干净的方法可以做到这一点？

Answer 1

出于好奇，我问了微软的 Barclay Hill，他为我回答了这个问题:

You can’t build database projects on machines unless they have VS or TFS 2010 installed on them. It is not a supported scenario. You can deploy database project build outputs without VS/TFS installed using vsdbcmd. The only way to do this and be in line with the licensing and support is to install a local copy of VS Pro or higher on your build box if not using TFS.