This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate.
I’m writing this more for myself than anyone else. I find myself using Data Masker for different databases at times, and I keep forgetting this. I just spent more than the 2 minutes I’d expect on Google searching, so I’m adding a post in hopes that I’ll remember this.
When you start creating a masking set, you’ll connect to a SQL Server and choose a database. Later, you might want to change this, or test the masking set elsewhere. Where is the connection string? I had thought it would be in the settings somewhere, but it’s not.
It’s in the controller.
The controller is usually at the top of the list, but there could be other ones. However, they are the most left displayed items.
Double click the controller, and you’ll see something like this.
Here you can change the instance and database needed. To save the changes for your session ,click the “Update Rule Controller” on the right. To save the changes in the set, save the entire set.
Hope this helps you, and hope it helps me remember how to do this.