Download MSSQL.DataMask

Download MSSQL.DataMask
Downloads: 706
License / Price: Freeware / $0
OS: Windows XP / Vista / 7
Last Updated: August 11th, 2010, 06:03 UTC

MSSQL.DataMask description

Quickly sanitizes a clone of your production 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 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). Data masking is an effective test data generation approach.

The MSSQL.DataMask application was developed to be 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 doc- umented tSQL script to modify, run, or schedule as your needs dictate.

What's New in This Release: [ read full changelog ]