DataSunrise Dynamic Data Masking for MS SQL Server
Data Masking for MS SQL Server databases guarantees business data protection against unauthorized access and data leaks. The tool obfuscates actual data in production databases to hide sensitive and regulated information, but keeps it looking realistic. Data masking prevents critical data exposure to non-privileged users.
With Data Masking for MS SQL Server sensitive and confidential information contained in databases is replaced with random or predefined values, so that the original data becomes unaccessible for non-authorized users. Masking of data is appropriate for the situations when a database is transferred to a third party for the purpose of application development, testing, analysis, etc. Also masking can be useful to limit data exposure to the employees within the company's to avoid intentional and unintentional data leaks. After masking is applied data remains looking realistic, but it becomes useless for any potential wrong doer.
DataSunrise provides static and dynamic data masking. With static data masking a stand-alone copy of the real database is created. The copy contains some neutral or randomized data instead of real sensitive data. Dynamic data masking is performed at the moment of request, on-the-fly. The actual database contents remain intact and only database output is obfuscated.
The tool obfuscates or randomizes database records according to the masking rules. DataSunrise provides general purpose masking methods and obfuscation algorithms for emails, credit card numbers, dates, time, etc. Users are also enabled to create their own masking algorithms.
This is how the table with masked columns looks like: