Visual Studio 数据库项目发布失败，没有错误信息 [英] Visual Studio database project fails to publish, no error messages
问题描述
我在同一个解决方案中有多个数据库项目.他们都无法发布.我的 Visual Studio 版本是 Enterprise 2015.我的 SQL Server 版本是 12.0.4459.0.
I have several database projects in the same solution. They all fail to publish. My Visual Studio version is Enterprise 2015. My SQL Server version is 12.0.4459.0.
过去在我的机器上正确发布的项目.他们在我的同事机器上正确发布.我没有更改我同事机器上正确发布版本的数据库项目.
The projects used to publish correctly on my machine. They publish correctly on my co-workers machines. I've not changed the database projects from the correctly publishing versions on my co-workers machines.
我用来发布的步骤如下:
The steps I use to publish are as follows:
- 我右键单击并选择发布.
- 我从 xml 文件加载发布配置文件.
- 我点击发布.
我期望发生的事情:显示 Data Tools Operations 窗口，项目发布成功.
What I'd expect to happen: The Data Tools Operations window is displayed and the project publishes successfully.
实际发生的事情:不显示数据工具操作"窗口.切换到数据工具操作"窗口时，它是空的.该项目未发布.Visual Studio 随后在关闭时正常运行.关闭 Visual Studio 时会显示一个对话框，提示发布时无法关闭解决方案".
What actually happens: The Data Tools Operations window is not displayed. On switching to the Data Tools Operations window it is empty. The project is not published. Visual Studio subsequently operates normally apart from when it is closed. On closing Visual Studio a dialog is displayed saying "The solution cannot be closed while publishing".
推荐答案
下面的旧答案对我有用过一次，但在随后的情况下时断时续.然后我注意到我实际上在 Visual Studio 的左下角显示了一个错误:
The old answer below worked for me once but was intermittent on subsequent occasions. I then noticed that I was actually getting an error displayed in the bottom left hand corner of Visual Studio:
来自 HRESULT 的异常:0x80041FE2 该选项卡已关闭.
Exception from HRESULT: 0x80041FE2 The tab has been closed.
Searching on the above returned this article: https://connect.microsoft.com/VisualStudio/feedback/details/827417/vs-express-2013-cannot-reopen-any-open-file-tabs-and-silently-closes-them-on-selection
所以我关闭了所有打开的标签页，然后就可以发布了.
So I closed all my open tabs and was then able to publish.
旧答案:要在点击发布后解决此问题，而不是点击加载配置文件，我点击了编辑并浏览到数据库服务器.然后我点击了测试连接.测试连接成功返回.然后，我为我的 SQLCMD 变量单击了 Load Values.点击发布后，数据库项目发布成功.
Old answer: To resolve this issue after clicking Publish, instead of clicking Load Profile I clicked Edit and browsed to the database server. I then clicked Test connection. The test connection came back successful. I then clicked Load Values for my SQLCMD variables. On clicking Publish, the database project published successfully.
按照上述步骤操作后，我可以通过在发布数据库对话框中单击加载配置文件的常用方法再次发布.
After following the above steps, I was then able to publish again by my usual method of clicking Load Profile on the Publish Database dialog.
这篇关于Visual Studio 数据库项目发布失败，没有错误信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
