更新目标按钮在 Sql Server 数据库架构比较中被禁用 [英] Update Target Button is disabled in Sql Server Database Schema Comparison
问题描述
我将 Visual Studio 2013 Professional Update 4 与多个 SQL Server 2012 Enterprise 服务器/实例结合使用.想法是使用带有 SQL Server 项目的 Visual Studio 解决方案创建一个受版本控制的部署.
I use Visual Studio 2013 Professional Update 4 in combination with multiple SQL Server 2012 Enterprise servers/instances. The Idea was to create a Version controlled deployment using a Visual Studio Solution with SQL Server Projects.
但是由于某种原因,更新目标"和生成脚本"按钮被禁用.
However for some reason the "Update Target" and "Generate Script" button is disabled.
我可以从 sql server 数据库更新本地数据库项目,但反之则行不通.(见截图)
I can update the local database project from the sql server database but the other way around is not working. (see screenshot)
Google 一点帮助都没有,尽管我发现一些人有类似的问题.
Google is not helpful at all although I found a few people with a similar problem.
但是这些问题/博文都不是关于 Visual Studio 2013 的,此外,没有一个提议的解决方案适合我.
But none of this questions/blogposts is about Visual Studio 2013 and in addition none of the proposed solutions is working for me.
问题:为什么更新目标"按钮被禁用,我需要更改什么才能解决这个问题?
Question: Why is the Update Target button disabled and what do I have to change to fix this?
注意:当然,我使用的是最新版本的 SQL Server Data Tools(12.0.50318.0)
Note: Of course, I'm using the latest version of SQL Server Data Tools(12.0.50318.0)
推荐答案
这也让我发疯.我终于注意到一条警告"消息,指出由于内部错误,无法生成部署计划".因此,更新和生成脚本按钮都被禁用.
This was driving me nuts, as well. I finally noticed a "warning" message stating "Cannot generate deployment plan due to an internal error". Because of this, the Update and Generate Script buttons were both disabled.
我通过关闭 Visual Studio、导航到包含数据库项目的文件夹并删除所有 (*.dbmdl) 文件解决了这个问题.然后我重新启动了 Visual Studio,重新运行了比较架构并启用了更新"按钮.
I resolved this by closing Visual Studio, navigating to the folder containing the Database project and removing all (*.dbmdl) files. I then restarted Visual Studio, re-ran the compare schema and the Update button was enabled.
这篇关于更新目标按钮在 Sql Server 数据库架构比较中被禁用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!