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

Apply an existing Data masking set to different database

Good afternoon,
How can I apply the current Data masking set to different database?  
i.e.  Current Data Masking set "MaskingSet_A" is on SQL Server "Test" with  "Test A" Database.  I would like to apply "MaskingSet A" to "Dev_A" Database which is also on "Test" SQL server.   (Test A and Dev A have a same tables/columns) 

Best Answers

  • Options
    PlantBasedSQLPlantBasedSQL Posts: 187 Gold 4
    Hi @bcnk thank you for your post!
    You can repoint a Data Masker masking set by opening the controller(s) and changing the database, testing the connection and then (to ensure that all the known indexes etc. are correct) refresh the tables and indexes, then re-save the controller.
    This should pick up the new Database connection and run absolutely fine if, as you say, schematically the databases are the same.
    Let me know if you have any issues with this!
    Thank you very much!
  • Options
    PlantBasedSQLPlantBasedSQL Posts: 187 Gold 4
    Excellent @bcnk
     Let me know how you got on :)


  • Options
    bcnkbcnk Posts: 18 Bronze 1
    Thank you so much for your quick reply.  I just opened the controllers and it looks like it should work.   I won't be able to test till next week but I think it looks great.   thank you for your help !  :)
Sign In or Register to comment.