Changing the SQL Data Masker Connection Target

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.

2019-09-02 14_28_27-SimpleTalk_Prod_Mask_ Data Masker for SQL Server

Double click the controller, and you’ll see something like this.

2019-09-02 14_29_14-Edit Rule Controller

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.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.