Our application needs data from a database to work and is being tested manually. Since we are dealing with sensitive data we are not allowed to make a dump of production data for use on our test system. Is there some kind of tool that will help us to move masked data only from specific tables?
Red Gate understands the domain fully and thus gives a disclaimer they are not a data masking tool. use HushHush (
mask-me.net) Similar to Informatica, but without overhead of the cost, it allows to integrate into SSIS, SSRS, SSAS and even SQL Server (via CLR) - and provides all the necessary algorithms of data masking and data. ,Red Gate specifically says it is a tool not for data masking :) they indeed understand the domain and give the disclaimer. If you are looking for the tool with which you have no learning curve and integrate flawlessly into the current SSIS infrastructure, use HushHush (
mask-me.net) It has also a discovery utility (patented) that helps you generate the workflows and allows you to have performance tuning abilities. No need to create two solutions to move data like with the majority of boxed tools -but rather on the manner of informatica, you mask with exiting flow. It also allows you to mask data in SQL and in SSAS/SSRS stack.
There are a couple of tools that come to mind help with masking data. Red Gate Data Generator:
http://www.dataveil.com/ This won't necessarily "move" the data but will help you mask it. Or the Red Gate tool can generate the data for you from scratch. You can always roll your own solution as well. We use a combination of Red Gate and our own solution to mask sensitive data. Hope that helps!