Apply an existing Data masking set to different database

bcnkbcnk Posts: 18 Bronze 1
in Data Masker for SQL Server
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) 
Tagged:
· Share on Twitter

Best Answers

  • PlantBasedSQLPlantBasedSQL Posts: 187 Gold 4
    Answer ✓
    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!
    Kindest
    · Share on Twitter
  • PlantBasedSQLPlantBasedSQL Posts: 187 Gold 4
    Answer ✓
    Excellent @bcnk
     Let me know how you got on :)
    · Share on Twitter

Answers

  • 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 !  :)
    · Share on Twitter
Sign In or Register to comment.