使用数据库项目在 tfsbuild 中构建错误 [英] Build error in tfsbuild with database project
问题描述
我已经在 TFS Build 中设置了我的 .NET 项目.它在本地构建良好，但我在服务器上收到此构建错误:
I have setup my .NET project in TFS Build. It builds fine locally, but I am getting this build error on the server:
未找到导入的项目C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets".确认 <Import> 声明中的路径正确，并且该文件存在于磁盘上.
The imported project "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.
我不知道它是什么，甚至谷歌搜索也没有多大帮助.我的解决方案有一些数据库项目.这里有什么问题，我该如何解决?
I have no idea what it is, even googling didn't help much. My solution has some database projects. What is the issue here and how I can fix it?
推荐答案
您需要安装 构建代理<上的 noreferrer">SQL Server 数据工具/a>.在安装 TFS Build 服务器时，人们通常会在该机器或其他机器上创建代理.
You need to install the SQL Server Data Tools on all build agents. When installing a TFS Build server, people often create agents to be on that or other machines.
您可以从 MS SQL Server 数据工具博客 或 Microsoft SQL Server Data Tools，然后选择与您进行的构建相对应的一个(Visual Studio 2010 或 Visual Studio 2012).
You can download them from the MS SQL Server Data Tools Blog or Microsoft SQL Server Data Tools, and you choose the one that corresponds to the builds that you doing (Visual Studio 2010 or Visual Studio 2012).
注意:在某些情况下，错误提到了路径:c:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets
在这种情况下，请从 SQL 安装中安装 SQL Server Data Tools，而不是上面的链接.
Note: In some cases, the error mentions the path:
c:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets
In such cases, install SQL Server Data Tools from SQL installation, not the link above.
这篇关于使用数据库项目在 tfsbuild 中构建错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
