获得MSBuild和CruiseControl .NET来构建和部署VS2010数据库项目 [英] Getting MSBuild and CruiseControl .NET to build and deploy VS2010 database projects

问题描述

我几乎都拥有一个可以构建和部署VS2010数据库项目的NAnt脚本，但是我遇到了一个错误:

I almost have a NAnt script together that will build and deploy VS2010 database projects, but one error stands in my way:

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的情况下，有什么干净的方法可以做到这一点?

I can see that the Microsoft.Data.Schema assemblies are not in the MSIL GAC on the build server - is there any clean way to do this without a full-freight installation of VS2010 on the build server?

推荐答案

出于好奇，我问微软的巴克莱·希尔(Barclay Hill)，他为我回答了这个问题:

For the curious, I asked Barclay Hill at Microsoft who answered this for me:

您不能在以下位置构建数据库项目 机器，除非它们具有VS或TFS 在其上安装了2010.这不是一个 支持的方案.您可以部署 数据库项目构建输出，不包含 使用vsdbcmd安装VS/TFS.这 做到这一点并保持一致的唯一方法 与许可和支持是为了 安装VS Pro的本地副本或 如果不使用，则在构建框上更高 TFS.

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.

这篇关于获得MSBuild和CruiseControl .NET来构建和部署VS2010数据库项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！