Simple tool/steps for obfuscating/scrubbing production data

Question

I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting.I would like to insert a scrubbed subset of the production data into a new database table that my co-worker can access. Please suggest best approach to achieve this.

Answer 1

The simplest way is to update the data after copying it to a new table to something that meets enough criteria forit to still be used.

We have a function that does a replacement of letters by letters, spaces by spaces for textual data, and randomised number for numbers.