Project

General

Profile

Forums » Help »

Database mirgration

Added by Yves Bailly almost 14 years ago

Hello,

(please forgive my english, it's not my native language)

We're happily using Redmine 0.8.4, the database being stored in an SQLite file.

Now we need to upgrade our server: new OS (will be Ubuntu 10.04 64bits), new various things... and new Redmine.

What I would like to do is to change the support database, i.e. from SQLite to PostgreSQL. Searching in the howtos, upgrade notes, forums... didn't yield any helpful result.

Did I miss something? or is it simply not possible for now?

Thanks in advance for any hint.

Best regards,

YB


Replies (1)

RE: Database mirgration - Added by Felix Schäfer almost 14 years ago

This is a rails issue (rails takes care of the whole DB thing for redmine), but the short answer is: not possible.

Longer answer: you can't just dump the DB and reload it into another because the DB adapters from rails do some optimization (e.g. on MySQL a boolean is stored in a tinyint(1) field, might be different on other DBs). There might be some rails plugins or whatnot to dump a DB through rails into some exchange format that you could reload on the other side, but I haven't needed and tried anything, so no idea how good they work, and lastly there is a plugin by edavis10 on github (I think the plugin is redmine_from_redmine) that merges 2 redmines into one that could do the trick for you, but AFAIK it's not "officially" released because not all content types are copied as of now.

    (1-1/1)