I need to take production data with real customer info (names, address, phone numbers, etc) and move it into a dev environment, but I'd like to remove any semblance of real customer info.
Some of the answers to this question can help me generating NEW test data, but then how do I replace those columns in my production data, but keep the other relevant columns?
Let's say I had a table with 10000 fake names. Should I do a cross-join with a SQL update? Or do something like
UPDATE table
SET lastname = (SELECT TOP 1 name FROM samplenames ORDER By NEWID())