Follow

Mask/anonymize customer database

WHEN 

When Pronestor needs a database from a customer where confidential information has to be removed/masked/anonymized

 

WHY

Some customers requires that a copy of Pronestor database can't leave their servers due to confidential reasons - it might be an option that we help them mask or anonymize their data.  

 

HOW TO SOLVE

IMPORTANT - please ensure that the script IS NOT executed on the production database but on a COPY of the data. 

  1. Make a backup of the production database - stored it to production.bak
  2. Restore the production.bak to a new test database
  3. Execute the attached mask.sql on the test database
  4. Make a backup of the test database - and set it to Pronestor
  5. Delete the test database from your server
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk