My company's user naming schema changed and we like to apply the new naming schema on our existing Trac instance. We already added the new users, so new tickets and changes will use the new names. What's left to do is to migrate the user names for existing tickets and changes so our existing reports and statistics remain useful.
We are using trac 0.12 with sqlite as database. In principle it should be enough to take a look at the Trac database schema, find all tables with fields containing user names and issue SQL update statements. Still it probably takes a couple of hours to get everything right, so I'd rather use an existing tool than write something from scratch.
Any recommendations?
(We also need to change the user names in our Subversion repository. svndumptool seems to solve this using svndumptool transform-revprop svn:author oldname newname repo.dump newrepo.dump.)
The best place to look for tools like this is a website called Track Hacks. A quick search there turned up three potential solutions for renaming users.
I hope that one of these can help you out.