Tag: dacpac

Azure Synapse is failing to perform the deployment giving error “type Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider is not valid”

azure-synapse dacpac sql sqldwdatabaseschemaprovider

I am working on Azure Synapse. I am able to build the Azure Synapse project successfully using the Azure CI pipeline’s MS Build task. But as I am trying to deploy Azure Synapse using the Azure CD pipeline, I am getting the following error. I am deploying the DacPac using the following task. I hope this should not be any

Can I generate a deployment script from a dacpac

dacpac msbuild publish sql

I’ve got a .dacpac file that’s being called by MSBuild and published to a QA database for testing. This publish is failing and the error I’m getting back from them is a generic “an error has occurred” message. I was hoping I could generate the deployment script from the dacpac and walk through it to see where the problem is