MSSQL.DataMask Description

Sponsored Links


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"



Publisher: | Download

Category: Business > Database Management

Size: 2.37MB

OS: Win 95/98/Me/NT/2000/XP/Vista/7

Downloads: 17534

License: Freeware

More Software Like MSSQL.DataMask

Maple Professional

Maple Professional is the flagship of the tree outline managers for power users that enables you to create your own hierarchical trees for storing information such as documents, notes, and images.
Downloads: 21228 - Shareware - Download Now

ABC Amber TBB Converter

ABC Amber TBB Converter is intended to help you convert The Bat! (popular e-mail client) databases (TBB files) to DBF or CSV format easily and quickly. All you have to do is select required messages, choose format to convert and click Save button.
Downloads: 20277 - Shareware - Download Now

Navicat Premium for Linux Cross-database Admin Tools for MySQL, SQLite, Oracle and PostgreSQL

Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, SQLite, Oracle and PostgreSQL databases simultaneously within a single application, making multiple database administration so easy.
Downloads: 20108 - Shareware - Download Now

MSD Documents Multiuser

MSD Documents Multiuser is a documents manager and a correspondence manager for networks. Both modules allow to catalogue the information by many different fields and may print an unlimited number of different reports.
Downloads: 20671 - Shareware - Download Now

DBF Manager

The convenient and feature-rich DBF file structure has survived for decades despite the ever-increasing rate of progress in the world of information processing.
Downloads: 20637 - Shareware - Download Now

Sponsored Links