Encrypting data on test database
We copy our production database to our development server periodically for performance testing etc.
I want to modify personal information on that database so that it becomes unidentifiable. I'm looking for a process that is quick an effective but doesn't require much control.
I was originally thinking of something like "translate" but I suspect this would take ages because of the volume.
Any suggestions?