Additionally, there are some tools that can assist with the Database cleanup. I've used Mass Password Reset https://www.drupal.org/project/mass_pwreset several times. You'll need to install and run it on a copy of the site that needs to be scrubbed. It can give some quirky error messages when resetting user #1 but otherwise, works well.
Alternatively, Acquia's Cloud-Hooks repository has a script that may be useful. However, you'd need to figure out how to integrate it into your workflow. https://github.com/acquia/cloud-hooks/blob/master/samples/db-scrub.sh
Pierre G. Berryer
2300 Clarendon Blvd., Suite 925
Arlington, VA 22201
On this topic, here are a few tools that may help with cleaning out your user data. I haven't used these myself. Generally the approach would be to create a copy of your site, then apply these tools. DO NOT run them on your live site!
Drush comes built-in with several commands of this nature. Try the site below and do a search for "sanitize". The descriptions don't seem to be to useful but the commands sound promising.
The Scrambler module, which has quite low usage but might be a good fit (if it works, etc):
The Sanitize Framework module looks like a bit of a "use it at your own risk" situation:
Martin Hansen Team Lead, Web Services 519.725.7875 x2120 | 888.817.3048
PeaceWorks™ Technology Solutions 101 - 554 Parkside Drive, Waterloo ON N2L 5Z4 www.peaceworks.ca
Mission driven technology solutions
This communication is intended for only the party to whom it is addressed and may contain information that is privileged or confidential. Any other distribution, copying or disclosure is strictly prohibited and is not a waiver of privilege or confidentiality. If you have received this telecommunication in error, please notify the sender immediately by return email and delete this message from your computer.
Please note: If you do not wish to receive promotional emails from us, please reply to this message indicating your preference and we will refrain from sending further promotional emails.