What are the challenges you face when working across database platforms? Take the survey

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

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?


Best Answer

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com


Sign In or Register to comment.