Repointing a set of rules from one database to another

pete29

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

TheMaskedData

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!

pete29

Thanks!  I figured I had to be overlooking something simple.