CODEWITHSUNDEEP
azureazure-devopsazure-pipelines-release-pipelinedacpacsqlpackage
Sindu_
Sindu_

Reputation: 1455

sqlpackage.exe to ignore a specific schema in DevOps Release pipeline

I want to ignore changes to a specific schema in the release pipeline in DevOps. I am trying to find the Sqlpackage.exe command for it. I checked the document here: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver15 but couldn't find it. I am using DACPAC Deployment as shown below:

enter image description here

Any help on this please?

Upvotes: 5

Views: 2279

Answers (1)

Shamrai Aleksander
Shamrai Aleksander

Reputation: 16018

SqlPackage can not ignore schemas. However, you can try an extension for SqlPackage: https://github.com/GoEddie/DeploymentContributorFilterer

It adds additional options for SqlPackage:

/p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments="SqlPackageFilter=IgnoreSchema(BLAH)"

Upvotes: 5

Related Questions