在Sql Server数据库架构比较中禁用更新目标按钮 [英] Update Target Button is disabled in Sql Server Database Schema Comparison
问题描述
但是由于某些原因,更新目标和生成脚本按钮是禁用。
我可以从sql server数据库更新本地数据库项目,但是其他方式不能正常工作。 (见截图)
Google没有任何帮助,尽管我发现有几个人遇到类似的问题。
但是这些问题/ blogpost都没有关于Visual Studio 2013此外,所提出的解决方案中没有一个适用于我。
问题:为什么更新目标按钮被禁用,更改以解决这个问题?
注意:当然,我正在使用最新版本的SQL Server数据工具(12.0.50318.0)
好。我终于注意到一个警告消息,指出由于内部错误而无法生成部署计划。因此,更新和生成脚本按钮都被禁用。
我通过关闭Visual Studio解决这个问题,导航到包含数据库项目的文件夹和删除所有(* .dbmdl)文件。然后我重新启动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.
I can update the local database project from the sql server database but the other way around is not working. (see screenshot)
Google is not helpful at all although I found a few people with a similar problem.
Update target button is disabled after schema comparison
VS2012: Schema compare, update button disabled
VS2012 Schema compare buttons disabled
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?
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.
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屋!