I am administrator of a FogBugz installation for a client with very strict rules about protecting data. Occasionally, I find, or have reported to me, bugs which seem to lie in FogBugz. Often, the best way to get these resolved would be to submit the database, but I am not in a position to do so. It would be great if someone could provide a mechanism (e.g. a MySQL script, a standalone script or executable which can modify MySQL dump file, or even a plug-in) which does, at a minimumn, the following:
- Drop the attachment table (except maybe for entries which correspond to icons used by FB - I think some are stored here)
- Anonymize all names, e-mail addresses, and phone numbers in the user database (to e.g. User #1, etc)
- Anonymize all projects (renaming them to e.g. Project #1, etc), and the names of the contact person for each project
- Anonymize all areas (e.g. Area #1, etc, for each project)
- Replace all text in all case titles, bug events, wiki articles, and discussion pages with, say, X's (this seems preferable to just blanking them out in case some problems depend on the amount of text in a field)
It's also necessary to address tags, word lists, custom bug data, etc...
I'm having a difficult time figuring out everything that would need to be done to denature the database in this way, much less the best way to do it. I can't be the only one in the position of having a database full of proprietary data and FogBugz problems to sort out, so I think this might make a very useful addition to FogBugz.
