Feature #3125

Merging 2 different Redmine Installations

Added by Ashwin Muni about 3 years ago. Updated over 2 years ago.

Status:New Start date:2009-04-06
Priority:Normal Due date:
Assignee:- % Done:

0%
Category:-
Target version:-
Resolution:

Description

I have redmine installed in 2 systems A and B.

Redmine Specs
Version : 0.8.0

I want both the redmine version to be merged to one now. Does redmine has any such feature where i can merge the database from other redmine installation or location.

Redmine A                       Redmine B
              IP 192.168.1.1                  IP 192.168.1.100
Want both to merge

So that the results would be 

Redmine ( A + B )  = Redmine (Final)

Please provide me the soln.

Ashwin

migrate.txt - General migration.. (6.5 kB) Magnifier Kiall Mac Innes, 2009-04-29 15:08

migrate2 - Merging 2 user accounts after the migration... (1.2 kB) Kiall Mac Innes, 2009-04-29 15:08

History

#1 Updated by Jean-Philippe Lang about 3 years ago

Sorry, there's no such feature.

#2 Updated by Kiall Mac Innes about 3 years ago

I recently merged a trac and redmine database in a way that may work for you..

Basically - i used the trac importer to create a redmine DB from the trac one. then the existing redmine DB was merged into this new one..

See the attached SQL queries as a base for what your going to need to to on the "to be deleted db" - after all these queries, you can export the data from the old db, and just insert them into the new one..

Aka - Pick one of your existing installs to the the final one and merge the other DB into it ...

The queries i used DO NOT COVER all circumstances - we has been using a limited set of trac features and a limited set of redmine features... You'll need to add more queries...!

#3 Updated by Kiall Mac Innes about 3 years ago

Note... all those numbers in the queries represent the MAX from the corresponding table from the DB u pick as the "final one" ...

Eg all the 380's in the "//User IDs" section are because on the "final db" "SELECT MAX AS max FROM users" returns 380...

Good luck - its not easy.

#4 Updated by Zarooba Rozruba about 3 years ago

A warnings : if you have anywhere references to ticket numbers, in text as opposed to db schema based link, then it will start pointing to a wrong location.

For example:

redmine a : commit comment : closes # 123
redmine b : commit comment : closes # 123

When merged, commit comments will stay intact, while one of them will have their tickets renumbered. This will cause some confusion.

If I can bring up my own related need : see ticket #3087

#5 Updated by Chris Born about 3 years ago

This very closely relates to a forum post I made just yesterday about moving a single project from one Redmine install to another. I began looking at the DB to see what it would take, then just ran across this. I was thinking of a possible solution for this being a project export/import feature. This would be really helpful, either project based merger or full Redmine install.

#6 Updated by Eric Davis over 2 years ago

  • Priority changed from Urgent to Normal

I just recently completed a plugin that will let you merge two Redmine database together. It worked for my customer, but I need to add some documentation before I can create a release of it. If you're interested, it's located at http://github.com/edavis10/redmine_merge_redmine

Also available in: Atom PDF