glennfishwick
IS-IT--Management
Does anyone have or know of any good (and fast) routines to anonymise data in a table.
I need to jumble up customer details in our database for testing purposes. I have a script that does this but it uses cursor's and runs like a dog!
All that I need to do is swap names around or update names with random names from a lookup table.
I need to jumble up customer details in our database for testing purposes. I have a script that does this but it uses cursor's and runs like a dog!
All that I need to do is swap names around or update names with random names from a lookup table.