Mailing List Archive

RT 2 to RT 3.8 migration tools
Hi all,

After almost 8 years of happily running RT 2.0.15 we've finally had
the guts to migrate to RT3.8.4. For this I had to write a few scripts
to make it faster than the tools that are available (rt-2.0-to-
dumpfile and dumpfile-to-rt-3.0).

Last week we've migrated, and I must say that it was relatively
painless. After much thoughts I'd like to share the code with the rest
of the world.


After migration we saw a noticeable increases in database rows on
certain tables, due to 660k tickets and 670k users:

old new
CachedGroupMembers: 0 6m+
GroupMembers: 368 2.7m
Groups: 60 3.3m
Principals: 0 4m
Watchers: 643k 0

That scared me at first, but it's not an issue on modern hardware. The
time taken for each of the stages you really need to do:
rewriting the original data: 26 to 48 minutes
importing into postgres: 16 to 65 minutes
recreating indexes: 11 to 35 minutes
Your mileage may vary depending on the amount of internal memory.


I've made my git repository readable and browsable:
http://bonsai.xs4all.nl/cgi-bin/gitweb.cgi?p=rt-migration.git

I'll be happy to answer questions or receive some critics on it.


Kai

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com