Update Target Button is disabled in Sql Server Database Schema Comparison
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.
- How important is the order of columns in indexes?
- SQL Server, to normalize this much or not?
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Big difference in Estimated and Actual rows when using a local variable
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- SQL - How to insert unique id in XML tag
- What represents a double in sql server?
- Insert leading spaces, then the value to a varchar(10) column
- TSQL Count 'Where' Condition
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- SQL fill gaps with hold
- Create Index without name while creating table
- How can I update top 100 records in SQL server?
- Why can't I use table names of aliased tables in WHERE clause?
- Base64 encoding in SQL Server 2005 T-SQL
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- SQL Server truncates decimal points of a newly created field in a view
- Why use a READ UNCOMMITTED isolation level?
- Recursive CTE and how to overcome circular reference error
- TRIM is not a recognized built-in function name
- How to calculate a rolling sum for a group of data
- Using SELECT to obtain only fields with alphanumeric data (and certain punctuation) in SQL Server
- Unable to Create Multiple User Defined Functions in SQL Server Using System.Data.SqlClient
- Get the database name in which Stored Procedure exists
- Convert Month Number to Month Name Function in SQL