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?
Asked
Active
Viewed 1,454 times
2
-
Out of interest, why the migration? – David Pashley Jun 05 '09 at 08: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 05 '09 at 12:42
-
Fairly sane reason :) Here, have a +1 – David Pashley Jun 06 '09 at 21:03
1 Answers
2
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.
Sean Preston
- 388
- 3
- 9