How to rum multiple maskingsets while automating

• 

  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

   

  Jon_Kirkwood October 26, 2023 03:39

  - 0 +
• 
  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

  bin_1 November 14, 2023 11:03

  - 0 +

Add comment

Please sign in to leave a comment.