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: 25444

License: Freeware

More Software Like MSSQL.DataMask

Blue TreePad manager

Award winning, pioneer Tree-structured personal database/PIM + text editor w/ advanced search: powerful time-saver that fits on a floppy & highly intuitive way for storing/retrieving notes, emails, texts, hyperlinks, etc. Easy to use as Win-Explorer!
Downloads: 26051 - Freeware - Download Now

Business Analysis Tool Desktop

Business Analysis Tool Desktop is a Business Intelligence software for data visualization and OLAP reporting. You can analyze data by making pivot tables, charts, treemaps and dynamic scatter diagrams. See more at:
Downloads: 26056 - Shareware - Download Now

DBSync for SQLite and MSSQL

DBSync for SQLite and MSSQL converter and synchronizer provides SQLite to MS SQL and MS SQL to SQLite data migration and synchronization with the ability to choose particular tables to be converted by configuring options in a wizard-like application.
Downloads: 25689 - Shareware - Download Now


MsSqlToAccess is a data conversion tool that helps DBA and database programmer convert MS SQL Server data to Access. Main features: 1. Easy visual configuration. 2.Converst from both table and query. 3. Displays progress through time estimation.
Downloads: 25855 - Shareware - Download Now

Treek's Password Manager

Treek's Password Manager (TPM) was developed to provide safe place to store your passwords, credentials and other confidential notes. TPM allows you create multiple databases and uses strong military-grade encryption to protect your data.
Downloads: 0 - Freeware - Download Now

Sponsored Links