up vote 2 down vote favorite
1
share [g+] share [fb]

I am in the process of migrating a request tracker 3.6 instance from one server to another. The old server uses PostgreSQL and the new one will use MySQL. Is there a way to migrate the data from one database to another?

link|improve this question
75% accept rate
Out of interest, why the migration? – David Pashley Jun 5 '09 at 8:24
I love PostgreSQL but in this case the destination server already has MySQL for some other systems data and so it does not make sense to run PostgreSQL just for Request Tracker. It would be just one more system to maintain and backup. – Sean Preston Jun 5 '09 at 12:42
Fairly sane reason :) Here, have a +1 – David Pashley Jun 6 '09 at 21:03
feedback

1 Answer

up vote 2 down vote accepted

After some more searching and getting the terms correct I came across the following: http://rt.bestpractical.com/view/PgToMySQL and linked from there is a Perl script that will do the required migration. It will need DBI and the mysql & postgresql drivers but seems to work pretty well.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.