February 6, 2011 at 2:49 pm
Data on Dev Server
I am planning to set up seperate Dev, Production and reporting environments.
But there is a polciyt that says Dev DBs shoudl not have the Production Data.
If i want to stick by that policy, how would I get data on to my Dev databases?
do i copy all teh data and then scrmble teh name, address or credit card numbers ?
But that sounds like a hell of work,
Can anybody tell me how this things works in your companies ? or whats the standard approach for this ?
Thanks
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
February 6, 2011 at 5:01 pm
What you are looking for is data masking. In my previous company, we used functions with custom algorithm which would change data in development every time it is refreshed from production. For example take the VIN number of car, the first 17 characters identifies the model of the car and last 7 uniquely identifies the car. So we would scramble only the last 7 digits. Look at this site, it has some great information on data masking. There are also some 3rd party tools available. I have not tested them.
http://www.grid-tools.com/solutions/data_masking.php
Hope this helps.
February 9, 2011 at 8:07 am
An option is getting data masking as a service, then you don't have to worry about buying the software etc.
We provide data masking services using the gartner top rated Camouflage software.
We also have Data discovery to find all the sensitive information that requires masking.
Cheers,
Adrienne Mennell
Plato Group Inc
Feel free to contact me at: amennell@platogroup.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply