[rt-users] Migrating certain tickets from one RT instance to another

[Nathan Cutler]

Hello everyone.

I'm about to embark on an RT migration from an existing instance
(running 4.0.13) to a new one (also 4.0.13). My use case is somewhat
specific in that:

1. the RT user ID values are different between the two instances
2. I only need to migrate open tickets (<50) so some manual work is OK

So far I'm thinking along these lines: make a user ID mapping table
(old -> new). Do the same for the queues. Export the open tickets as
SQL. Apply the mapping to the resulting text file (simple
search-and-replace). Apply the SQL to the new instance.

The only idea I have come up with (so far) to generate the SQL for a
particular ticket is Shredder. It seems like it might work, but before
I try it (on a copy of the database, of course), I thought I'd ask
here: Is this a reasonable course of action? Is there a better way to
achieve the same end?

Thanks,
Nathan