Icon of program: MSSQL.DataMask

MSSQL.DataMask for Windows

Download now

Used MSSQL.DataMask for Windows?

Editors’ Review

Download.com staff
MSSQL.DataMask sanitizes production database copies into secure test databases. It offers three masking types for PII and PHI protection, ensuring safe and repeatable data refreshes.
Enlarged image for MSSQL.DataMask
MSSQL.DataMask 0/1

  • Pros

    • Sanitizes production database copies for safe testing.
    • Free and simple tool for data masking.
    • Supports repeatable test data refreshes.
    • Offers three distinct data mask categories.
    • Generates documented tSQL scripts for customization.

  • Cons

    • Primarily focused on SQL Server databases.
Icon of program: MSSQL.DataMask

MSSQL.DataMask for Windows

Download now

Used MSSQL.DataMask for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1.0.0.7
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows 2003
  • Windows Vista
  • Windows Server
  • Windows XP
Additional Requirements
Microsoft .NET Framework 3.5
POPULARITY
Total Downloads
142
Downloads Last Week
1
Report Software

Program available in other languages

Last Updated

Developer’s Description

By WinTestGear
MSSQL.DataMask sanitizes a copy of your production database into a test database.
Do you need rich test data to develop, test, or outsource your project? If so, you've probably tried either generating from scratch, or cloning from production data. Auto-generating the test data is difficult and error prone for all but the simplest databases due to complex variances, frequencies, and data interdependencies. Business and legal obligations such as HIPAA require that production data clones be thoroughly sanitized (masked) of personal indentifiable information (PII) and/or protected health information (PHI). MSSQL.DataMask is a free, simple tool that quickly sanitizes a clone of your production database into a safe, secure test database. Once built, the process is easily repeatable to refresh your test data from production. You can either load and re-run a set of data masks from the application, or generate a fully documented tSQL script to modify, run, or schedule as your needs dictate. Why mask your test data? Ã??? Creating test data is more complex and doesn't always represent actual business scenarios versus masking (anonymizing) production data Ã??? Most data breaches come from within an organization; thus, protecting your dev and test data is critically important. There are three categories of datamasks: 1. Scrub: Overwrite all rows of a column with the "same value" 2. Substitute: Overwrite all rows of a column with a new "unique value" 3. Transform: Overwrite all rows of a column with an "obsfucated original value".
Download.com
Your review for MSSQL.DataMask