dbanonymizer

This is a DB Anonymizer config generator for drupal sites. DB Anonymizer is a tool that can:

1. Do full/partial data export from database.
2. Anonymize data on the fly during the export.

Why do I need it?

Have you ever faced some issues that require you to copy a DB from live site to your local site to debug and fix it? In some cases this may be not a straight forward task, because:

• Live DB may take dozens GBs of space.
• It may contain some sensitive data that developers should never see, e.g: real names, passport numbers, phone numbers, etc.

Using DB Anonymizer you can create a partial DB dump that has for example 5% of actual data and anonymize it. And yes - if some table has related data in other tables, it could be exported as well. You can configure the amount of data to export for each table.

Usage

1. Install and enable this module as usual.
2. Go to /admin/dbanonymizer-config-generator page, where you can copy generated config for your site.

Keep in mind that you may still need to change this config to fit your needs, but this would be a good starting point as generator had done all the hard lifting for you. Think of some custom db tables (and their relations) that your site may have, consider adding them to the config as well. You might also want to add anonymization config for some tables (e.g. fields).

Then you can use that config as usual, see DB Anonymizer readme for more details.
Also check this module readme for some highlights.