VS2013 installation breaks SQL Server Data Tools in VS2010

After installation of Visual Studio 2013, an existing SQL server data tools project in VS2010 on the same machine would no longer build. The exception in the error window read “The “SqlBuildTask” task failed unexpectedly. System.MissingMethodException: Method not found: ‘Void Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.Serialize” (…)

Fortunately, the solution was rather simple. It turns out there is a new version (October 2013) of the SQL Server Data Tools available at the Microsoft download site. Simply installing that over my existing installation fixed things. Note that I did get a Visual Studio conversion wizard the time first opened the project after that, but that conversion went seamlessly.

SSDT installation succesful
SSDT installation succesful

Thanks to Michael Mairegger for the tip. He had the same issue after installing a service pack for SQL server management studio.

Note that the same also appears to apply to VS2012.


Reacties

Eén reactie op “VS2013 installation breaks SQL Server Data Tools in VS2010”

  1. […] although the dacpac’s and other projects remain fully compatible throughout 2010/2012/2013. The update to SSDT that was released at the time VS2013 came out, was the last one. Personally, I am only keeping my VS2010 around for its Installer support, so I […]

Geef een reactie

Je e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *