search

GoEddie / DeploymentContributorFilterer

MIT License
69 stars 34 forks source link

Required Contributor error with SQL Server 2017 #11

Closed palmerc7 closed 5 years ago

palmerc7 commented 5 years ago

I came across this much-needed tool to publish only specific schemas between databases. I downloaded the latest build and copied the AgileSqlClub.SqlPackageFilter.dll to the folder: C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin.

During my publish I get this error: *** An error occurred during deployment plan generation. Deployment cannot continue. Error SQL0: Required contributor with id 'AgileSqlClub.SqlPackageFilter' could not be loaded. Contributor initialization error.

My sqlpackage command does include these parameters: /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments="SqlPackageFilter=IgnoreSchema(DataSync)"

Am I missing something in the usage or is this a Bug?

t-johnson commented 5 years ago

If you downloaded the ZIP file from github and extracted it, you might need to right-click the dll and "unblock" it.

RoyC-Retail-Assist commented 5 years ago

The project uses Microsoft.SqlServer.DacFx.x64 v15o.x.x. Downgrading this to v140.x.x. allows it to work with SQL Server 2017 version of sqlpackage.exe

palmerc7 commented 5 years ago

If you downloaded the ZIP file from github and extracted it, you might need to right-click the dll and "unblock" it.

I did verify that the DLL was un-blocked. Same result. Just saw your new build as well. Trying that.

palmerc7 commented 5 years ago

Closing issue