Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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