Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Masking Your On-Premises Database With SQL Data Mask

DZone's Guide to

Masking Your On-Premises Database With SQL Data Mask

Redgate is announcing a version of SQL Data Mask that would mask on-premises SQL Server databases, as well as Azure SQL Databases.

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

Things move fast in Foundry, Redgate’s research and development division. In our last update three weeks ago, we announced our intention to build a version of SQL Data Mask that would mask on-premises SQL Server databases, as well as Azure SQL Databases. We’re pleased to say this version is now available.

We’re working closely with a select group of people who are helping us test and iterate this solution; our goal is to make sure SQL Data Mask is able to satisfy your masking requirements.

How Does It Work?

If you’ve previously tried SQL Data Mask, you’ll know that it’s available from Redgate Foundry (as with all our prototype tools). This is also the starting point for masking an on-premises SQL Server database.

Now when you log into Redgate Foundry and open SQL Data Mask, you’ll see the option to download the on-premises version:

Once installed, SQL Data Mask will launch automatically and look very similar to the web version (we’ll talk more about how we’ve done this soon). Simply log in to the application in the same way that you log in to Redgate Foundry.

Logging in helps us work more closely with users so we can develop SQL Data Mask with your help (in fact, you can talk to us in-app by clicking the red bubble in the bottom-right corner any time).

The first time you use SQL Data Mask, you’ll need to grant it permission to access your Azure or Microsoft account:

Choose the SQL Server and database you want to mask and specify where you want the new masked database to be created:

The server list gets populated by auto-discovering the servers in the network available to the machine where SQL Data Mask is installed. Also, notice that you have the ability to use SQL Server Authentication if you prefer.

SQL Data Mask will scan your database for sensitive data and if a table contains columns with data it thinks should be masked, it will identify it with an icon:

Select the table to view the column masks being applied, and modify them if necessary:

Once you’re happy, hit Start Masking and let us know how you get on!

What Next?

Naturally, we’ll continue to make SQL Data Mask more robust, capable, and flexible, but we’re also interested to know more about where data masking fits into your workflow.

Do you need to share information about the masking choices you made in order for colleagues to be able to reuse it? Would those choices change over time, or would they likely stay true forever? Send us and let us know.

In the meantime, head over to Redgate Foundry and try SQL Data Mask now — we’d love to hear how well it masks your database for you.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:
sql ,database ,data mask ,redgate

Published at DZone with permission of Santiago Arias. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}