Security & Privacy    Other     MSSQL.DataMask


Description of


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".

Published by: WintestGear
Downloads: 1388
File Size: 2.4 MB
License: Freeware
Product Homepage: Visit WintestGear
Release Date: 28 April, 2010
OS: Windows Vista , Windows , WinXP
Requires: .NET Framework 3.5.
Download Location: Primary Download Link Broken? Report it!
Editor Rating:

MSSQL.DataMask Download Tags:
Personal Identifiable Information    Protected Health Information    Scrub Data    Substitute Data collects software information directly from original developers using software submission form. Sometimes it can happen that software data are not complete or are outdated. You should confirm all information before relying on it. Using crack, serial number, registration code, keygen and other warez or nulled soft is illegal (even downloading from torrent network) and could be considered as theft in your area. Files32 does not provide download link from Rapidshare, Yousendit, Mediafire, Filefactory and other Free file hosting service also. The software has been submitted by its publisher directly, not obtained from any Peer to Peer file sharing applications such as Shareaza, Limewire, Kazaa, Imesh, BearShare, Overnet, Morpheus, eDonkey, eMule, Ares, BitTorrent Azureus etc..
More Software from WintestGear

MSSQL.SchemaDiff by WintestGear

MSSQL Schema Diff is a free database comparison tool used to quickly and easily locate structural differences between two SQL Server databases.

License:  Freeware
Platform:  Windows
File Size: 430.5 KB


TCMLite by WintestGear

TCMLite 1.0.2
Simple Excel-based Test Case Management tool for writing&executing test cases. TCMLite is a free, simple, highly configurable test case management tool enabling. Use TCMLite to design, write,...

License:  Freeware
Platform:  Windows
File Size: 2.1 MB


File Touch by WintestGear

File Touch
Need to reset a file's date&time created, last modified, and/or last accessed? FileTouch modifies date/times on individual files, or sets of files. Simply run the single executable (no install...

License:  Freeware
Platform:  Windows
File Size: 119.0 KB


MSSQL.DataMask Related Software

DBSync for FoxPro & MSSQL by DMSoft Technologies

DBSync for FoxPro & MSSQL 2.0
DBSync for FoxPro & MSSQL is a database synchronizer which performs MS FoxPro to MS SQL and MS SQL to FoxPro database conversion and synchronization simply by configuring several options in a...

License:  Shareware
Platform:  Windows
File Size: 11.9 MB
Cost: $69.00


MSSQL-to-Access by Southern Ocean Software

MSSQL-to-Access 2.3
MSSQL-to-Access is a program to convert MS SQL databases into MS Access format. All MS SQL data types and attributes are supported. MSSQL-to-Access is a program to convert MS SQL databases into MS...

License:  Shareware
Platform:  Windows
File Size: 2.2 MB
Cost: $49.00


Access-to-MSSQL by Southern Ocean Software

Access-to-MSSQL 2.3
Access-to-MSSQL is a program to move MS Access databases to MSSQL server. All MS Access data types and attributes are supported. Access-to-MSSQL is a program to move MS Access databases to MSSQL...

License:  Shareware
Platform:  Windows
File Size: 697.0 KB
Cost: $49.00


MySQL to MSSQL 4.1
MySQL to MSSQL converts MySQL databases into MS SQL Server format MySQL-to-MSSQL is a program to convert MySQL databases into MS SQL Server format.Features1. All MySQL data types and attributes are...

License:  Shareware
Platform:  Windows
File Size: 384.0 KB


Excel-to-MSSQL by Southern Ocean Software

Excel-to-MSSQL 1.1
Excel-to-MSSQL is a program to migrate MS Excel data into MS SQL databases. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. All versions of MS Excel are...

License:  Shareware
Platform:  Windows
File Size: 7.6 MB
Cost: $29.00


MSSQL-to-Oracle by Southern Ocean Software

MSSQL-to-Oracle 1.5
MSSQL-to-Oracle is a program to migrate MS SQL databases to Oracle server. All MS SQL data types and attributes are supported. The program has easy-to-use wizard style interface and works with all...

License:  Shareware
Platform:  Windows
File Size: 540.0 KB
Cost: $49.00


Mini Desktop Stopwatch by

Mini Desktop Stopwatch 1.0
This stopwatch and countdown timer helps you getting things done faster. Set short deadlines for yourself and start working - the timer will help you staying focused on the task.

License:  Freeware
File Size: 4.1 MB

File Touch by WintestGear

File Touch
Need to reset a file's date&time created, last modified, and/or last accessed? FileTouch modifies date/times on individual files, or sets of files. Simply run the single executable (no install...

License:  Freeware
File Size: 119.0 KB

Top Software

FTP Rush 2.1.8
FTP Rush is a free comprehensive FTP client for smooth file transfer. The program offers fully-fledged functionality delivered in a user-friendly interface and allows experienced users to create...

Crypt4Free by

Crypt4Free 5.47
Crypt4Free is files encryption software with ability to encrypt files and text messages. Support for ZIP files and ability to secure delete sensitive files. Skinnable user friendly interface.

Luxand Blink! by

Luxand Blink! 2.0
Login to your PC without touching a thing! Luxand Blink! is a free tool to let you log in to your Windows account by simply looking into a webcam - no passwords to type and no fingers to scan.

InTask Personal by

InTask Personal 1.5
InTask designed to help team leaders, developers and QA persons to share their efforts and deliver the products on time. The product includes fast task management, interactive gantt, document...

Pop-up Free by

Pop-up Free 1.56
Get rid of annoying popup windows and enhance your Web surf experience. Kill unexpected popup windows and protect your privacy. No more annoying advertisement windows and save your time.

Glary Utilities Portable by

Glary Utilities Portable
One Click A Day For PC Maintenance, Keeps Any PC Problems Away. With 7 million worldwide users, the first-rank & free Glary Utilities is an INDISPENSABLE friend for your PC, with its 100% safe,...

VPSpro by

VPSpro 3.695
VPSpro is the ultimate in the creation of financial projection and general business plans. The unique walk-through process is simple to use and makes easy work of the hard parts of business planning.

Rylstim Budget Lite by

Rylstim Budget Lite
Plan and manage your finances with a simple friendly calendar. Perfect solution for home users and freelancers!

Neox Screen by

Neox Screen
Neox Screen is a free application which with the help of the hotkeys you can take screenshots that are crystal sharp, small in size and ready to be shared.

EMCO Remote Installer Free by

EMCO Remote Installer Free 4.1.1
This free remote software deployment tool is designed to install and uninstall Windows software on remote PCs through local networks. You can use it to install and uninstall EXE setups and MSI...

Latest Software

WavePad Masters Edition by

WavePad Masters Edition 8.02
WavePad Masters Edition for Windows is sound editing software for Windows. This program lets you make and edit voice, music and other audio recordings. You can use the cut, copy, and paste feature...

TATEMS Fleet Maintenance Software 4.6.24g
TATEMS 20/20 Fleet Maintenance Software Program has been Making Life Easier For Fleet Managers because they have FINALLY DISCOVERED a system that is SO SIMPLE and SO EASY TO USE ...

Decipher TextMessage 11.2.8
Save iPhone text messages to computer to keep a running history of SMS, iMessage, and MMS messages on your Windows PC. Recover lost and deleted text messages. Print text messages or export to PDF.

Start Menu 8 by

Start Menu 8
Start Menu 8 is a desktop customized utility for Windows users, specifically designed to bring back the familiar Classic Start Menu to Windows 8/8.1 & Windows 10.

HelpSmith by

HelpSmith is a complete help authoring tool for CHM, Web Help, and Printed Manuals Creation. Dynamic Styles, NO HTML Coding principle combined with the tool's useful features make help authoring a...

Random Number Generator Pro by

Random Number Generator Pro 2.18
Random Number Generator is a application designed to generate random numbers.

Blackjack Systems Analyst by

Blackjack Systems Analyst 2.0
Test and Analyze Blackjack and Spanish 21 Systems. See a graph of Bankroll Balance, and view statistics as a simulation progresses. Export data to a spreadsheet program. Practice your system as...

ACDSee Ultimate by

ACDSee Ultimate 2018.2.1309
With GPU-accelerated adjustment layers, RAW editing, and an arsenal of professional digital asset management tools, ACDSee Photo Studio Ultimate 2018 is perfectly positioned as the only software...

Photovoltaic System by

Photovoltaic System 3.00
Simulate the amortization of a Photovoltaic System over 30 years, including Prosumer Electricity Network Trading. Fine-tune as many cost-driving, efficiency, and sales parameters as you want. See...

Net Monitor for Employees Professional by

Net Monitor for Employees Professional 5.5.8
The Net Monitor for Employees is employee monitoring software that allows you to see screens of remote computers or show your screen to students. This spy software allows you to take control of a...

IObit Malware Fighter by

IObit Malware Fighter
With the newest Bitdefender antivirus engine, anti-ransomware engine and the much improved IObit anti-malware engine, IObit Malware Fighter 5 supports removing the latest spyware, adware, Trojans,...

quickSMTP by

quickSMTP 0.1
quickSMTP is a fast and efficient mail server for Windows and is fully compliant with SMTP and POP3 specifications. It is free for use and provides a variety of features, such as: comfortable...

Related Searches

Currently Searching

Currently Downloading

Use Simulator for MS Outlook 2003 Mail by

Use Simulator for MS Outlook 2003 Mail 1.1
Reference: \\ask by pointing\\ on all Microsoft Outlook 2003 email screens. Practice: more than 100 email tasks on interactive Outlook interface - step by step and explained. Remember: proficient...

MaintainShip Standard 2.0
Inventory and maintenance tracking for ship managers MaintainShip is a powerful multi-user shipboard tool for managing engineering department information.

Pixar DPG Converter by

Pixar DPG Converter 2.7
Pixar DPG Converter is the right solution to convert nearly all video/audio formats like AVI, MPEG, H.264/AVC, 3GP, VOB , DAT, WMV, MP4, DivX, MOV, WMA, WAV, M4A, AAC, etc. to DPG/DPG2/DPG3/DPG4...

Pass4sure Microsoft 70-029 by

Pass4sure Microsoft 70-029 2013
One of the best and most rewarding features of the 70-029 training materials are that they are guaranteed to bring you success in the testing room.

System Safety Monitor
System Safety Monitor monitors all running processes and operating system activity in real-time, and allows you to control exactly what is happening on your PC.

PDF to TIFF server license by

PDF to TIFF server license 6.5
PDF To TIFF Converter is a perfect convert tool for PDF documents, which can helps you convert PDF documents to TIFF (Tagged Image File Format). Original document layout is fully preserved.

Pension Actuary 7.0
The program allows you calculate pension annuities and/or pension contributions for non-state pension funds, based on actuary mathematics.

WinFax PRO Macro for Word XP/2000/2003 by

WinFax PRO Macro for Word XP/2000/2003 2.02
Now you send faxes directly from Microsoft Word XP/2002/2003 or Word 2000 without switching the printer driver to WinFax PRO or TalkWorks. You can also send mail merge faxes to all your Outlook...

CaptionsMadeEasy CaptionViewer by

CaptionsMadeEasy CaptionViewer 1.2.1
CaptionsMadeEasy CaptionViewer - Easy Caption Editor & Slideshow Viewer. CaptionViewer easily adds captions to your photos and then lets you view the photos with captions as slideshows. Now...

Desktop Budget Lite by

Desktop Budget Lite
In a world where most of us have a negative net worth, managing finances is a key way to reach your financial goals. Desktop Budget Lite will help you reduce loans, pay off your credit cards or...

Free Video to DVD Converter by

Free Video to DVD Converter
Free Video To DVD Converter converts videos of any video format to a DVD format and burns them to a DVD disk, which can be played on any home DVD player.

Wondershare DVD Audio Ripper 3.1.26
Wondershare DVD Audio Ripper is a very powerful DVD audio ripper program with very intuitive and user-friendly interface. It can rip audio from DVD to MP3, WAV, AAC, AC3, WMA and M4A etc with...