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

License: Freeware

More Software Like MSSQL.DataMask

Movie Library Organizer Pro

Movie Library Software for Windows. Movie library database maintenance system for private, public, corporate libraries. Our library software helps you to catalog dvds, video tapes, cds, organize member information, keep track of the circulations.
Downloads: 22248 - Shareware - Download Now

Navicat for PostgreSQL GUI Admin tool (Linux) - Support Import or Export and compatible with i386 PC

Navicat - PostgreSQL Client - a GUI Tool for PostgreSQL admin and Access to PostgreSQL, Excel to PostgreSQL conversion. Navicat is a set of graphical database management, reporting and monitoring tools for PostgreSQL database systems.
Downloads: 22647 - 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: 22102 - Shareware - Download Now

MySQL Sybase ASE Import, Export&Con

Transfer tables to and from MySQL and Sybase ASE (Adaptive Server Enterprise) databases. Importing and exporting can be done without SQL knowledge.
Downloads: 22211 - Shareware - Download Now

Timecode Log & Calculator

Video production environment timecode log and calculation tool. It contains time saving features such as automatic time-colon entry, calculated Scene/TRT durations in both hh:mm:ss:ff and frames as well as error detection flagging routines.
Downloads: 22495 - Shareware - Download Now

Sponsored Links