sql-servercontinuous-integrationdacpacsqlpackage

DACPAC - How to deploy one particular schema

I've been looking to find ways to deploy one particular schema (Schema B) from database (Schema A, Schema B, Schema c..) using dacpac and sqlpackage.exe.

I found this similar question but looks like the links on it have been archived. also found out to put this parameter in sqlpackage.exe cmd DropObjectsNotInSource = false but still both schema are getting deployed. can anyone help?

Solution

  • I found out this can be done using this DeploymentContributorFilterer.

    Put the AgileSqlClub.SqlPackageFilter.dll file into the same folder as SqlPackage.exe, and add these commmand line parameters to your deployment:

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