I have full access to both databases, but clearly a MySQL dump file isn't going to import cleanly into Postgres. Are there any good step-by-steps for migrating from MySQL to Postgres?
Asked
Active
Viewed 1,297 times
2 Answers
1
There are a few MySQL -> PostgreSQL migration resources linked from the PostgreSQL wiki. I've never tried migration with Redmine though.
PostgreSQL 8.2 is quite old now, is it provided by a hosting provider, or can you use a more recent version?
![](../../users/profiles/30942.webp)
hmallett
- 2,425
- 14
- 26
0
I've used SQL::Translator to do mysql to postgres conversions in the past. Worked pretty well for me.
![](../../users/profiles/20441.webp)
James
- 7,553
- 2
- 24
- 33