I need to anonymize some data from our production server so that I can review the data for further business opportunities. For example, I use the Adventureworks database.
Let's say I have the data as in the table below and I have to anonymize it all.
It would be good to have names in the right form and not some gibberish like Axpsr Raqnclo. The account ID could be anything just numbers or combination of numbers and letters.
Is there any good solution to this or some tool for this? I know that for account ID I can use function RAND() in SQL but no idea how to do the rest.
I'm using SQL Server with SSIS and SSAS.
Any ideas please?