Search code examples
sql-server-data-tools

Build error : Incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer

I have a Visual Studio 2012 project that reports an error from msbuild when trying to publish the database from the command line:

Microsoft.Data.Tools.Schema.SqlTasks.targets(390,5): Build error : Incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer.

I have checked and installed all updates for VS2012 SSDT and everything is up to date.

Solution

  • The trick was to install SSDT updates for Visual Studio 2010 - despite the fact that my solution was running in VIsual Studio 2012. The solution was upgraded from 2010 so perhaps that is why there is the dependency.

    Another clue was in the path to the build target - v10 not v11

    C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(390,5): [error message followed]