GoEddie / DeploymentContributorFilterer

MIT License
73 stars 35 forks source link

Azure Data Studio #39

Open PlaidPhantom opened 1 year ago

PlaidPhantom commented 1 year ago

Hi, has anyone figured out how to use this with Azure Data Studio's Publish command? I've tried setting up a publish profile and adding the parameters as new properties, but so far this seems to get ignored:

(my.publish.xml)

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <TargetDatabaseName>[ ... ]</TargetDatabaseName>
    <TargetConnectionString>[ ... ]</TargetConnectionString>
    <AllowIncompatiblePlatform>True</AllowIncompatiblePlatform>
    <DropPermissionsNotInSource>True</DropPermissionsNotInSource>
    <DropObjectsNotInSource>True</DropObjectsNotInSource>
    <DropRoleMembersNotInSource>True</DropRoleMembersNotInSource>
    <IgnoreKeywordCasing>False</IgnoreKeywordCasing>
    <IgnoreSemicolonBetweenStatements>False</IgnoreSemicolonBetweenStatements>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <AllowDropBlockingAssemblies>True</AllowDropBlockingAssemblies>
    <ProfileVersionNumber>1</ProfileVersionNumber>
    <AdditionalDeploymentContributorPaths>C:\path\to\dll\</AdditionalDeploymentContributorPaths>
    <AdditionalDeploymentContributors>AgileSqlClub.DeploymentFilterContributor</AdditionalDeploymentContributors>
    <AdditionalDeploymentContributorArguments>SqlPackageFilter=IgnoreSchema(rpt)</AdditionalDeploymentContributorArguments>
  </PropertyGroup>
</Project>
t-johnson commented 1 year ago

personally i've never had luck with this property in the deployment profile xml file, wheras the command line parameter has worked:

/p:AdditionalDeploymentContributorPaths=c:\path