Geek Answers Handbook

Visual Studio 2013 build error: incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer

I have Visual Studio 2012 and Visual Studio 2013 installed on my development machine. My SQL projects were created using VS2013 and they compile fine from Visual Studio, but they do not work with the following message when I use MSBuild from the command line:

Build Error: Incompatible versions of SQL Server Data Tools and components on the desktop database are installed on this computer.

Note. This error was encountered by other developers in Visual Studio 2012. See this SO question . I have confirmed that my SSDT versions are updated. I am not dealing with the same problem.

+4
source share
1 answer

To fix this problem, you should make sure that you are using MSBuild 12.0, which comes with Visual Studio 2013, and not with MSBuild 4.0, which comes with the .NET 4.0 infrastructure.

Make sure your path does not include the .NET 4.0 framework, and then add MSBuild 12.0 to your path as follows:

SET PATH =% PATH%; "% ProgramFiles (x86)% \ MSBuild \ 12.0 \ Bin"

Another solution is to set the VisualStudioVersion property to 12.0 as follows:

MSBuild.exe My.sqlproj / p: VisualStudioVersion = 12.0

Note. The same error message appeared in many different versions of SSDT. This hotfix applies to Visual Studio 2013

+5
source

More articles:


All Articles