• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1202
  • Last Modified:

How to scramble production data?

I'm looking for a tool that can take production data and scramble it so that developers will not be looking at production data when working in a dev environment.  Can someone suggest any free or inexpensive tools that provide this functionality?
1 Solution
Bill BachPresidentCommented:
By the fact that you posted this in the PeachTree forum, can we assume that you want to obfuscate PeachTree data?

I'd start here:

Any "real" effective tool would have to be custom-written for the data set in mind, or at least be able to identify WHICH fields to mangle through a setup process.  This is critical because a tool would never know which fields are important to the functionality of the program and which ones can be safely scrambled.  (See the white paper on the above site.)

The tool Data Masker on that site won't hit Pervasive directly, but perhaps you can use SSIS to drag the data to SQLServer, mangle it, and then send it back.  Just a thought...

cgipisaniAuthor Commented:
I must've mistakenly tagged Peachtree, but it doesn't look like I can change the zone now.  I downloaded the datamasker you suggested earlier, and I'm still waiting to receive an evaluation license key from them.  In the meantime, I decided to start writing my own because I'm only looking to mask certain fields like first/last name, dob, ssn, etc.  It seems like a fairly straightforward task.  
Checkout JumbleDB Express on www.orbiumsoftware.com, It has a nice tutorial videos

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now