Working on a customer project which is an upgrade of Visual Studio 2008 and SQL Server 2005 projects up to the latest Visual Studio bits and pieces.
Upgrade of most solutions went fine, except for the database projects. On a build locally you would get the following error:
The "SqlBuildTask" task failed unexpectedly.
System.MissingMethodException: Method not found: 'Void Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.Serialize(System.IO.TextWriter, System.Collections.Generic.IEnumerable`1<System.Type>)'.
at Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.SerializeModel(String outputFile)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteSerializeModelStep()
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__20.MoveNext() C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets
This issue was resolved by installing the SQL Server Data Tools (December 2012 update) from http://msdn.microsoft.com/en-us/jj650015
.