Update target button is disabled after schema comparison

visual-studio-2012 database-project sql-server-2012-datatools
Aruna picture Aruna · Jul 19, 2013 · Viewed 18.9k times · Source

I have created database project using VS 2012. Once the schema comparison is done, the update target button should be enabled to sync with target.

But it's not getting enabled. Any help plz.

I'm using VS 2012 with sp 3, SQL Server 2012,

enter image description here

Answer

Francisco G picture Francisco G · Aug 8, 2014

Check in Error List if you have any error, I have a non recognized word in VS (but it does in SQL Server), I commented it out, re-compared and it was enabled successfully.

Related questions

How to properly manage database deployment with SSDT and Visual Studio 2012 Database Projects?

I'm in the research phase trying to adopt 2012 Database Projects on an existing small project. I'm a C# developer, not a DBA, so I'm not particularly fluent with best practices. I've been searching google and stackoverflow for a few hours …

Read More
VS2012 Post-Deployment script referring to several other scripts

I have created a database project in VS2012. I added database structure. It works fine to publish and compare database. Now on publish I want to automatically load several tables with default data. I created five script files with INSERT …

Read More
Build error in tfsbuild with database project

I have setup my .NET project in TFS Build. It builds fine locally, but I am getting this build error on the server: The imported project "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.…

Read More