Database migration

Added by Ralf Gebhart over 10 years ago

Is there an easy way to migrate redmine's database from mysql to postgresql?
I could only find migration pathes from trac or mantis in the docs.
Some kind of export/import functionality would help, but I couldn't find that either.

Replies (8)

RE: Database migration - Added by Felix Schäfer over 10 years ago

That is a database matter, not a redmine matter, but I suppose you could export the stuff out of mysql as plain sql and reimport it into postgresql. I'm sure google can help you with that. (redmine doesn't care what the db is, as long as it's configured in database.yml and contains the same data)

RE: Database migration - Added by Ralf Gebhart over 10 years ago

Unfortunately it's not a question of dump the mysql db and putting it into postgresql.
The underlying rails stuff does completely other things in mysql then in postgres.
For example boolean values are stored as integers in mysql for performance reasons where it
expects real booleans on postgresql. Next problem is, that mysql has some strange ideas how SQL should look like sometimes.
I've tried converting other rails apps from mysql to postgresql , it's a non trivial job and
I succeeded only in one of 5 cases.
Converting it on SQL level is basically almost impossible :-(
That's why I asked if there's some import/export feature.

RE: Database migration - Added by Brian Wells over 10 years ago

This plugin might be useful for dumping the data and then importing it into the new database.

http://github.com/ludicast/yaml_db

RE: Database migration - Added by Felix Schäfer over 10 years ago

You might also have some luck with the redmine_merge_redmine plugin from Eric, but I'd suggest asking him directly what he would suggest for this, got to the IRC channel and aks him (his nick is edavis10).

RE: Database migration - Added by Viktor Berke over 6 years ago

You might succeed with the following guide:

Installing, Migrating & Upgrading Redmine with LDAP on Ubuntu

For me it failed when I tried converting from SQLite 3 to MySQL, but migration to PostgreSQL was working fine.

RE: Database migration - Added by john karippery 11 months ago

when i click that link
page is not found

could you give alternative guide. I also want to migrate sqlite to Postgresql
thank you

(1-8/8)