Moving a queue between RT servers

Hello,

We need to move an RT queue from one production server to another due to
internal reorganization. Both servers run RT 3.8.x . So a mysql dump &
restore of the tickets in the queue will be problematic as it might
cause ticket # conflicts.

Is there any easy/clean way of doing this?

Thanks - Edna

edna.vcf (268 Bytes)

Hello,

We need to move an RT queue from one production server to another due to
internal reorganization. Both servers run RT 3.8.x . So a mysql dump &
restore of the tickets in the queue will be problematic as it might
cause ticket # conflicts.

Is there any easy/clean way of doing this?

I’m just working on this and have to finish next week :wink:

I’m writing a script using sql on source DB and RT api on target DB.

Of course, tickets Id will be changed, but I plan to record the old
ticket in a CF. for reference.

Hello,

We need to move an RT queue from one production server to another due to
internal reorganization. Both servers run RT 3.8.x . So a mysql dump &
restore of the tickets in the queue will be problematic as it might
cause ticket # conflicts.

Is there any easy/clean way of doing this?

I’m just working on this and have to finish next week :wink:

I’m writing a script using sql on source DB and RT api on target DB.

Of course, tickets Id will be changed, but I plan to record the old
ticket in a CF. for reference.

As this may be useful for someone else, here is the script I made to
copy some queues from an RT 3.4.5 to an RT 3.8.8 with MySQL (should work
with most src RT >= 3.4.0 and target RT 3.8.x).

It is intended to be run on the target (RT 3.8.x). It will do some
direct sql to the src RT and create tickets in the target RT using the
RT API.

There is some limitations written at top of the script.

It’s a one shot script that is in the state of “it worked here, may be it
can be usefull for you”.

of course, there is no warranty that it may not destroy all your datas

sync-tickets.pl (32.7 KB)