How can we help you today? How can we help you today?

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)
bcnk
0

Comments

3 comments

Sort by
  • PlantBasedSQL
    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
    PlantBasedSQL
    0
  • bcnk
    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 !  :)
    bcnk
    0
  • PlantBasedSQL
    Excellent @bcnk
     Let me know how you got on :)
    PlantBasedSQL
    0

Add comment

Please sign in to leave a comment.