Follow the below steps to de-identify the PHI data as well as make the data size smaller by removing audit data:
- Make a copy of production DB
- Run below SQLs on the copy
- Export the data dump and import it into the test server.
Important: Do not run these SQLs on the production database.
...