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

Question

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://docs.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:

Any help on this please?

user_8235971 · Answer

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)"

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

1 Answers