I intend to use a SQL Server Database Project in my Visual Studio Solution to manage the database. This is a very nice feature and you should try it. Nevertheless, after upgrading the SQL Server Management Studio 2012 to SP1 I was not able to build the SQL Server Database Project anymore. I always got the following error message:
Error 2 04018: 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
After a few attempts, I found the solution. I just downloaded and installed the new version of SQL Server Data Tools and the exception has disappeared.