Is it possible to Automate the amendment of a Data Masker Controller?

RodEdwards

As per the title really, i'd like to programmatically amend the Server name in a Controller to cater for the same DB in different environments? ie.. DEV, Test etc... The rest of the Masking set would stay the same.

Is this possible? Or is it a case of save a copy manually with each pointing to a specific target?

Thanks
Rod

Eddie D

Hi Rod, Thank you for your forum post.

There is no command line or PowerShell cmd that will programmatically alter a MaskingSet's Rule Controller to point to a different database.  You will need to edit the Rule Controller via the GUI, for the details of the new or different SQL Instance, select the Tools tab (in the Edit Rule Controller dialog refresh Tables and Indexes.  Finally update the Rule Controller.

Many Thanks
Eddie

RodEdwards

Thanks Eddie!