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

License: Freeware

More Software Like MSSQL.DataMask

DBF to SQL Converter

The DBF to SQL program allows you to convert your dbf files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system. The program supports command line interface.
Downloads: 35433 - Shareware - Download Now

Devart ODBC Driver for Salesforce

Devart ODBC Driver for Salesforce provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce.com, Force.com cloud CRM and Database.com cloud databases from Windows, both 32-bit and 64-bit.
Downloads: 35653 - Shareware - Download Now

MySQL PostgreSQL Import, Export&Con

This application will allow you to transfer tables to and from MySQL and PostgreSQL databases. Importing and exporting can be done without SQL knowledge.
Downloads: 35505 - Shareware - Download Now

DTM Bulk Backup for SQL Server

The DTM Bulk Backup tool helps the user or administrator to backup a few SQL Server databases by one click. Just select databases and specify a folder to save backups. The tool is free. Try it right now!
Downloads: 35733 - Freeware - Download Now

DBSync for MS SQL and DB2

DBSync for MS SQL and DB2 is a two-way tool for an efficient conversion and synchronization from IBM DB2 to MS SQL or from MS SQL to IBM DB2. Unicode support, Primary keys and Indexes conversion, sessions support. Insert, Update and Drop sync.
Downloads: 35651 - Shareware - Download Now

Sponsored Links