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