Tuesday, 3 November 2015

DACPAC Error: Could not generate deployment report. (Microsoft.SqlServer.Dac

When you get error as following while deploying using DACPAC, then right click on the project, select properties. And in project setting tab ensure you have selected correct version of SQL Server as 'Target Platform' drop-down.

"Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql120DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)"

Hope this helps!