28 April 2017
28 April 2017

SQL Data Mask: now featuring configurable masks

SQL Data Mask is the latest prototype to come out of the Foundry. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge.

What we’ve been up to:

Progress on SQL Data Mask is advancing quickly. Based on the feedback you’ve given us, we’ve added the ability to configure how your data is masked:


SQL Data Mask, now with configurable masking

Configurable masking

Previously, we made a guess about what type of masking to apply to each column. For example, if the name of the column was FirstName, we would mask the values with other random first names. However, there was no way to choose not to mask a field, apply a mask to a field that the app didn’t think was sensitive, or customize how a field was masked.


Masking configuration for the customer table

In the latest version of the app, you can now edit what type of masking is applied to each field. The detecting behavior is still there, but we now use it to create some smart default settings that can act as a jumping off point for your own data masking requirements:

We also added some new mask types that can be used to mask sensitive data which doesn’t have a more specific mask. Here are some of the new masks we’ve introduced:

  • RandomFirstName: A random first name will be generated
  • RandomLastName: A random last name will be generated
  • RandomEmail: A random email will be generated
  • RandomVisa: A random visa will be generated
  • Nulled: The field will be replaced with null
  • RandomInteger: A random integer will be generated
  • RandomReal: A random real number will be generated
  • RandomDatetime: A random datetime will be generated
  • RandomString: A random string will be generated

Data Compare result of SQL Data Mask, using the previously shown masking configuration

Coming soon to a server near you

We’ve had a lot of feedback from people asking for an on-premise version of this tool. We’re working on this at the moment so keep your eyes peeled. In the meantime, you can check out the tool now.

Are we heading in the right direction? Help us shape what data masking by Redgate should look like. We’re always available to talk, either by email, or via the red chat link at the bottom right of the Foundry Labs page.

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in Blog

Why you should include the database in your 2020 IT strategy

It’s that time of year when business leaders and managers in organizations of all shapes and sizes are considering what the next 12 months’ strategy and beyond should look like. Specifically, what...

Also in Audit & Compliance

Enter data privacy. Exit SQL Server 2008.

SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implications, as James ...

Also about Foundry

SQL Server Configuration — the Redgate survey results

In the Foundry Team at Redgate, we’ve been looking into how data professionals manage the complexities of their wider data estates. One aspect of this is configuring, deploying and monitoring dr...

Also about SQL Data Mask

SQL Data Mask: new masking features, constants and composition

SQL Data Mask is the latest prototype to come out of Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data. You can use it to mask your databa...