How to scramble production data?

Posted on 2009-02-23
Last Modified: 2013-11-15
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?
Question by:cgipisani
    LVL 28

    Accepted Solution

    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...


    Author Comment

    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.  

    Expert Comment

    Checkout JumbleDB Express on, It has a nice tutorial videos

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This article describes some very basic things about SQL Server filegroups.
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now