Migration of data from other systems?

Greetings!

Has anyone had experience with data migration from other systems?

Specifically, we’re moving from Mantis to RT, both with MySQL backends
but on physically different systems. It would be nice if we could
preserve the historical data that currenly resides on the older system.

Has anyone done this with Mantis or any other trouble-ticket system?

Thanks!!!

…k
Kevin Freels
Director of Information Technology
Sendmail, Inc.
kfreels@sendmail.com 510/594.5572

Kevin,

Right now we are about to design a perl program that will read an 

Oracle DataBase and then use CLI to create the new tickets in RT. We
would REALLY be appreciative of anyone who could send us a good perl
model for that function. When we get it to work, we’ll definitely post it.

Kenn
LBNLOn 8/6/2008 12:17 PM, Kevin Freels wrote:

Greetings!

Has anyone had experience with data migration from other systems?

Specifically, we’re moving from Mantis to RT, both with MySQL backends
but on physically different systems. It would be nice if we could
preserve the historical data that currenly resides on the older system.

Has anyone done this with Mantis or any other trouble-ticket system?

Thanks!!!

…k
-=-=-=-
Kevin Freels
Director of Information Technology
Sendmail, Inc.
kfreels@sendmail.com 510/594.5572


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

   Right now we are about to design a perl program that will read an

Oracle DataBase and then use CLI to create the new tickets in RT. We
would REALLY be appreciative of anyone who could send us a good perl
model for that function. When we get it to work, we’ll definitely post it.
That seems to be the SOP, to script rt, but it’s not clear how one
preserves historic dates :-/

Another potentially lovely tool might be mbox2rt instead of the
existing rt2mbox.

Cambridge Energy Alliance: Save money & the planet