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".
Microsoft .NET Framework 3.5
Like it? Share with your friends!
Other Windows Software of Developer «WinTestGear»:
MSSQL.SchemaDiff MSSQL Schema Diff is a free database comparison tool used to quickly and easily locate structural differences between two SQL Server databases. Results are clearly displayed with MSSQL objects in a familiar SQL Management Studio tree layout and property co
File Touch When developing or testing software, there are times when you need to reset a file's date and time created, last modified, and/or last accessed. FileTouch modifies file date/times on individual files, or sets of files. Simply run the single executable (no
Advanced Privacy Protector Your computer tracks your activity on the Internet. Advanced Privacy Protector software protects your privacy by removing your Internet records and other temporary files from your computer. Deleting your browser cache and history will not protect you. Anyo
Automatic Windows and Internet Washer Your computer stores more information than you think. All over your hard drive is information about the sites you've visited, files you've opened, and people you've emailed. Automatic Windows and Internet Washer cleans any evidence of your Internet and Win
SinBin SinBin is aimed at all levels of users and it offers intuitive access to the Internet Explorer Cache database, giving full control over cookies, history, and the Web cache stored on your PC. Novice users can take advantage of preset common-search filters t
EG Folder Lock EG Folder Lock is an easy, simple, user friendly, fast and absolutely free software used to lock your important, sensitive folder (A folder contains folders, files, documents, images, videos) on your computer. The folder is password protected and cannot be
Delete Skype History Delete Skype History Standard Edition program solves the problem of the invasion of your privacy and clears your Skype footprint. The program deletes your chat history for one or more contacts of any time period on your local PC where it is installed.
Ashampoo Privacy Protector Ashampoo Privacy Protector offers a new security approach by combining encryption, archiving and trace removal in a single application. AES256-encrypted files can be instantly burned or emailed. There's also support for self-extracting archives for easy fi
Shadow Defender Is your computer safe? New security vulnerabilities are found every day by which many malicious programs or people attack the Windows operating system. Your computer may HAVE been attacked. Please protect your system with Shadow Defender ASAP. Shadow Defe
bVPN You can easily setup b.VPN on Windows, Mac, iOS and Android. b.VPN is simple and user-friendly with a very-easy-to configure interface. You only need to create an account, install the application on any device you want and log in to enjoy the benefits of a
System Purifier All-in-one file shredder, privacy eraser, disk cleaner, startup manager, free space wiper. File shredder securely deletes sensitive files (files can not be recovered). Disk cleaner scans for useless temporary junk files and frees space by deleting it. Priv
WX Lock F8 This software is the best technology for you protect your system from safe mode.
With the WX Lock F8 enabled, you no more need worry with your security and privacy.
It is light, stable and 100% reliable.
No installation required and also does not requi
Supported Operating Systems:
Windows XP |
Comments on MSSQL.DataMask:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10