0

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?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Prany
  • 2,078
  • 2
  • 13
  • 31

1 Answers1

0

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**)"
Prany
  • 2,078
  • 2
  • 13
  • 31