Options
Repointing a set of rules from one database to another
pete29
Posts: 4 New member
Hello,
My apologies if I'm missing something obvious. I've created a set of rules for a particular SQL Server instance and database. I'd like to reuse these same rules for a different copy of the database on a different SQL Server instance. How can I re-point my current masking set to use a different database while being able to retain the rules I've created?
Thanks
My apologies if I'm missing something obvious. I've created a set of rules for a particular SQL Server instance and database. I'd like to reuse these same rules for a different copy of the database on a different SQL Server instance. How can I re-point my current masking set to use a different database while being able to retain the rules I've created?
Thanks
Tagged:
Best Answer
-
Options
TheMaskedData
Posts: 50 Bronze 3
Hey @pete29 - you should be able to do this if you double click the controller (usually 00-001) at the top of the masking set and change the DB connection and schema (if necessary)
You will need to refresh the connection too, to make sure there are no major differences between the copies, although if the schema is the same you should be fine (although there may be different indexes at least which will need to be refreshed) - example on doing this here:
https://www.red-gate.com/hub/university/courses/data-masker/advanced-operations-with-data-masker/advanced-operations-with-data-masker/refreshing-a-masking-set-controller
Let me know if this helps! Thanks!
Answers