How to rum multiple maskingsets while automating

bin_1

Hi, we are using sql datamasker alone to mask the databases.
we have multiple masking sets which runs on 3 different databases.
in PARfile, we will mention only one masking set.

Jon_Kirkwood

Hi @bin_1

 

Thank you for reaching out on the Redgate forums with your SQL Data Masker question.

Regarding your query, I'm sorry to say that each parfile can indeed only point to one masking set at a time.

It may be worth noting that if you want to apply the same masking set to a different database with the same schema, this is possible, but you would still need to edit the parfile to change the target db connection as described here: 

https://documentation.red-gate.com/dms/data-masker-help/general-topics/about-command-line-automation/login-substitution-for-the-sql-server-command-line

 

More details on Command Line Automation can be found here:

https://documentation.red-gate.com/dms/data-masker-help/general-topics/about-command-line-automation

 

bin_1

Hi @Jon_Kirkwood, thanks for letting know that we can have only one masking set in each parfile.
we tried looping through all parfiles and tried to run using PowerShell command.

Also can we just parametrize the maskingsets with sql credentials?

for example in the below datamasking snippet we have enpassword value

<EnPassword Value="xxxxxxxxxxxxxx" />
Can we just replace that with below line?

<EnPassword Value="${sql_password}" />
where we can fetch the password from KV or azuredevops variables group