Project

General

Profile

Forums » Help »

Merging two databases

Added by Arseny Silvestrov about 16 years ago

Hello, everyone.

Does anybody have experience in merging two redmine databases?

I keep an instance of redmine. There's another instance of redmine running on other server. I take some data from that second server (scenarios for animations), add those scenarios to my instance, then this data is processed into animations by lots of people. So my instance serves to get scenarios on input and put animations on output. Then the output is returned to that second redmine tracker.

Now I want to merge two instances. My instance is kind of subproject to other instance, so I can't just substitute one database with another. So, how do I merge them? :)
I should mention, that two instances have slightly different structure, like I don't use different trackers for different kinds of animations, and the other redmine instance has that kind of separation.

I'm sure I forgot to mention something, so, please, ask for any additional info you want to know.

Regards,
Arseny


Replies (2)

RE: Merging two databases - Added by Eric Davis about 16 years ago

Merging two databases would be difficult like you said becasue of the different trackers, statuses, etc. Depending on your data, it might be easier to copy the data from one instance into the other (via a script). What data are you wanting to actually migrate over (e.g. issues, issue notes..)?

Eric

RE: Merging two databases - Added by Arseny Silvestrov about 16 years ago

I'd never been asking, if that was easy :)

I'm interested in issues and files attached to issues mostly. But other data (assignees history, comments and couple of custom fields) would be good to transfer too.
I have a possibility to bring my instance to the structure of this other one, but I'm not sure if this action would be of any use.

Arseny

    (1-2/2)