Scramble SQL Data

My boss has said I can use the company data for offsite test use if I can juggle the data so it names, numbers, address details etc nolonger match the original record. Can someone recomend a way to shuffle it all.

My idea would be to juggle from one column at a time with a routine.

Thanks in advance.

Hi James,

Why not use completely dummy data

There are several websites around (search for something like ‘test data names and addresses’) that offer free random test data already prepped for SQL databases

That way you don’t have to worry about either scrambling real data or using real data in the first place

Cheers
Harry

wouldnt some ssl connections be a better security?