How to make data unidentifiable?

Hello,

I am building a database to be used for demonstration purposes. I wish to import the data from an existing database into the demo. However I need to tranform the data from the existing database so that the data is unidentifiable but meaningful. For example, I need to change the First name, Last name, Address, city, state, zip, Social Security etc...so that they are different to the original database but still have meaning in the new database. E.g. A record such as:

Peter Paulas, 123 Main St, New York, New York, 10023, 555-342-3423 becomes something like:
Simon Trickle, 234 East St, Bronx, New York, 10023, 534-234-2333

I would like the transformed record: Simon Trickle, to still be linked to the remaining data that is not tranformed. Has anybody tried this before and if so, do you have any easy solution.

Thanks,
Joseph Received on Wed Jun 09 2004 - 12:00:49 CDT