Resource
Certification Resource
Forum
[Free] Freeware testing tool, [Paid] Commercial testing tool
![[Level:8]](http://www.vietnamesetestingboard.org/zbxe/modules/point/icons/default/8.gif "Point:1980point (11%), Level:8/30"){kind=icon}
2010.04.29 14:48:29
3089
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.
Link for more info: http://www.wintestgear.com/products/MSSQLDataMask/MSSQLDataMask.html
Screenshot - Main Form:
Using MSSQL.Datamask is simple. Run the executable. Click connect to open a database. Select a table in the tree control on the left. Click the column mask type drop down to open a mask selection dialog (shown below). As you assign data mask rules to table columns, they become bold in the grid.
Screenshot - Mask Selection Dialog:
There are currently 21 types of data mask that can be applied to columns. The list of mask types is filtered based on the column's data type, length, whether or not it is nullable, whether or not it has constraints, etc. As you select different maskt types in the drop down list, the dialog re-paints itself with detailed instructions on using the mask type and reconfigures the parameter text boxes / drop down boxes.
In the sample screenshot below, the Substitute value randomly from a list of possible values mask is depicted. Note that you can simply paste in a long list of names, addresses, zipcodes, phone numbers or whatever else you need (CRLF delimited). MSSQL.DataMask will then randomly substitute from this list to replace the actual values in your test database (cloned from production). In the example below, the [LastName] field is going to be randomly overwritten with values I keyed into the text box (John, Jack, Jim, etc.).
Screenshot - Auto-Generated tSQL Script:
MSSQL.Datamask automatically generates thoroughly commented tSQL for you if you'd rather not run your data masks from the tool's interface. Reasons you might choose to script include automating in a SQL Agent job, modifying the script yourself (to bypass limits MSSQL.DataMask enforces like no masks on primary keys when you know it will be safe, etc.).
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.
Link for more info: http://www.wintestgear.com/products/MSSQLDataMask/MSSQLDataMask.html
Screenshot - Main Form:
Using MSSQL.Datamask is simple. Run the executable. Click connect to open a database. Select a table in the tree control on the left. Click the column mask type drop down to open a mask selection dialog (shown below). As you assign data mask rules to table columns, they become bold in the grid.
Screenshot - Mask Selection Dialog:
There are currently 21 types of data mask that can be applied to columns. The list of mask types is filtered based on the column's data type, length, whether or not it is nullable, whether or not it has constraints, etc. As you select different maskt types in the drop down list, the dialog re-paints itself with detailed instructions on using the mask type and reconfigures the parameter text boxes / drop down boxes.
In the sample screenshot below, the Substitute value randomly from a list of possible values mask is depicted. Note that you can simply paste in a long list of names, addresses, zipcodes, phone numbers or whatever else you need (CRLF delimited). MSSQL.DataMask will then randomly substitute from this list to replace the actual values in your test database (cloned from production). In the example below, the [LastName] field is going to be randomly overwritten with values I keyed into the text box (John, Jack, Jim, etc.).
Screenshot - Auto-Generated tSQL Script:
MSSQL.Datamask automatically generates thoroughly commented tSQL for you if you'd rather not run your data masks from the tool's interface. Reasons you might choose to script include automating in a SQL Agent job, modifying the script yourself (to bypass limits MSSQL.DataMask enforces like no masks on primary keys when you know it will be safe, etc.).
Service
New
Popular Documents
Popular Download
Weekly
Monthly
Yearly
Twitter
tag
Visitor