Can't update with schema compare

sql-server visual-studio-2012 schema-compare
Kris Harper picture Kris Harper · Jun 6, 2013 · Viewed 28.7k times · Source

Up until today, I was able to use the Schema Compare feature in Visual Studio 2012 to update a database from a database project. But now, for one project I can do the compare, but the update button is greyed out.

I am able to use other projects to update other database, but from this project I can't update any databases. I do not get any errors, the functionality is just unavailable.

Using publish still works. Also updating the project from the database works, just not the other way around.

Does anyone know why I wouldn't be able to update a database via Schema Compare?

Answer

mark picture mark · Sep 5, 2013

Check the bottom of the screen after a compare it shows status messages there. I've seen this issue if there is a compile error in the database project. Once the error is resolved close and reopen the compare dialog. Rerun your compare and the Update button should be available again.

Related questions

Where is the SQL Query Analyzer in SQL Server Management Studio 2012

I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. application. I have SQL Server Management Studio 2012 installed.but i am not able to find SQL Query Analyser. Any Input …

Read More
update the database from package manager console in code first environment

Code First Environment I'm trying to update the database from package Manager console.If my Domain class change, I have to drop and create the database,Instead of dropping the Database how can i update the database. I have already …

Read More
EF5: Cannot attach the file ‘{0}' as database '{1}'

I'm encountering the exact issue as described here (read section "Cannot Attach to Deleted MDF File"), but the solution to the problem is not told there... In short the issue is that after deleting the .mdf file, the following exception …

Read More