After a periodic copy for production to our testsystem, we need to anonymize the personal data according to the new Data Protection Act in Europe. Unfortunately also keyfields of db-tables are affected, because we use the social security number as account key in the subledger module FS-CD.
We know that you can't change the key of a DB-table but instead have to copy the entry, save it with the new key an delete the old one. We are still on a R/3 EHP8 system with a MSSQL DB.
Is there any experience on solving such an issue or a 3rd party tool to handle it?