Merge Databases from two different RT setups

Happy New Year!

I guess this is a MySQL problem, except that RT has complicated it :wink:
Our company, with itā€™s own RT site, is merging with another company
after a marriage;) They also have their RT!!

To consummate the marriage, Iā€™d like to be helped out by external
parties (yourselves) in how I can marry this bride, with all her
luggageā€¦

Is there a way to merge two RT databases?? I just want to rule this
out, if anythingā€¦

    cheers
   - wash 

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
ā€œOh My God! They killed init! You Bastards!ā€
ā€“from a /. post

I see a plethora of problems with this, mainly with ticket ID
collisions. Say you were at least able to change the range of one group
of tickets so as not to incur conflicts - but then all existing email
referring to those tickets wouldnā€™t be good anymore. Seems like youā€™d
have to hack in some mapping table (ticket that was 1234 is now 123400)
so that the system knew how to handle it.

My suggestion would be to make one the ā€œofficialā€ installation going
forward, and then donā€™t allow any new tickets in the other, just resolve
them and make the old instance read-only. Or set the old instance to
read-only from the beginning, and create new tickets in the new system
whose content is everything from the ticket in the old system, and put
the old ticket ID in the subject for reference. That way, someone can
still find their old ticket to work on it, but it has a non-colliding ID
in the new system. I did something similar to the second suggestion
when migrating open tickets from a propietary in-house system to RT.
But make sure everyone closes as much as they can in the old system
first so you donā€™t have much to migrate :-)-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Odhiambo
Washington
Sent: Friday, January 13, 2006 7:31 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Merge Databases from two different RT setups

Happy New Year!

I guess this is a MySQL problem, except that RT has complicated it :wink:
Our company, with itā€™s own RT site, is merging with another company
after a marriage;) They also have their RT!!

To consummate the marriage, Iā€™d like to be helped out by external
parties (yourselves) in how I can marry this bride, with all her
luggageā€¦

Is there a way to merge two RT databases?? I just want to rule this out,
if anythingā€¦

    cheers
   - wash 

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi,
KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita
St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI
|
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9
|
ā€œOh My God! They killed init! You Bastards!ā€
ā€“from a /. post
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from Oā€™Reilly Media at
http://rtbook.bestpractical.com

WEā€™RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html