How can we help you today? How can we help you today?

Ignore dynamic mask doesn't work for Azure devops plugin?

Hi team,

I set the   <IgnoreDynamicDataMasking>True</IgnoreDynamicDataMasking> in the ComparisonOptions.xml. 
I can see that sql source control in the SSMS is ignoring the mask. But the DevOps 'Create a database release artifact' step still generating the sql with alter table.

Am I doing a wrong practice or the DevOps plugin doesn't support the feature? 

SQL Change Automation: Release, version 4.2.2

Many thanks,
Weinan
yeweinan
0

Comments

1 comment

Sort by
  • Eddie D
    Hi, thank you for your forum post.

    SCA PowerShell version does not make use of the ComparisonOptions.xml created using SQL Source Control.  

    The user needs to set the required SQL Compare options within the cmdlet they are using, for example the New-DatabaseArtifact - 

    <table><tbody><tr><td><code>New-DatabaseReleaseArtifact -Source <Object> -Target <Object> [-FilterPath <string>] [-IgnoreStaticData] [-SQLCompareOptions <string>] [-SQLDataCompareOptions <string>] [-IgnoreAdditional] [-TransactionIsolationLevel <TransactionIsolationLevel>] [-IncludeIdenticalsInReport] [-AbortOnWarningLevel <WarningSeverity>] [-IgnoreParserErrors] [-SqlCmdVariables <hashtable>] [-CodeAnalysisSettingsPath <string>] [-DriftFiltering <DriftFiltering>] [<CommonParameters>]
    <br>Many Thanks<br>Eddie

    Eddie D
    0

Add comment

Please sign in to leave a comment.