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 databases right now, free of charge, so download the latest on-premises version.
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.
New masking features
Over the last few weeks we have introduced new masking features that are more flexible than the default masks.
You can now define a constant value for a column field that will be used in all rows of that column.
The first iteration of the composition mask allows you to compose multiple masking types together. In this example you can create an email address by composing 4 different steps.
- First Name mask
- Constant “.” mask
- Last Name mask
- Constant “@example.com” mask
As we move forward we expect this composition workflow to allow you to reference other column values. Other masking features we’re considering are:
- Constraints: The value of a column depends on values of another column (eg, start date should never be after end date)
- Ranges: Allow the ability to define the range of values or dates
- Offsets: Allow the ability of offsetting many dates at random
We’re increasing the development effort on SQL Data Mask. More on this coming soon.
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.
Also in Blog
Once a year, we hold Down Tools Week at Redgate. It’s our version of a hack week – a chance to put down the day job and spend a week working on something completely different. It’s an opportuni...
Also in Redgate products
SQL Monitor's dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare h...
Also in Software development
In this post, we imagine how auto-classification of data can be used to build better documentation that helps you trust that your organization can use data without posing a risk or compromising regu...
Also about data masking
This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.
We build ...
Also about SQL Data Mask
SQL Data Mask is the latest prototype to come out of the Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data. You can use it to mask your da...