Mask/anonymize customer database


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



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.  



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 send 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


Powered by Zendesk