Redmine

make sure you are running same version of redmine on both, schema changes can happen between versions.

Info on the destination server says:

Redmine 0.8.4.stable (MySQL)

while on the existing server it's:

Redmine 0.8.4.stable.2798 (MySQL)

Is that enough of a difference to force me to upgrade the destination server? Feel free to infer from the fact that I used the BitNami stack that I'm not well versed in administering Ruby apps.

thx

Overall it would be nice to have some Project import/export ability so we can extract all the project data from one server and put it into another.

This is not a common task but sometimes there are some migrations that need to occur and this feature will be nice to have.

Is there a web page/documentation some where describing how to export one project from one Redmine instance to another one? (I do see the need to have the Redmine instances at the same version but what else do I need to do?)

+1

+1 Indeed this is an realy needed feature!
I googled around and I simply did not find a save way to export a project (with all its tickets and used users and all) and import it into an other redmine instance.
attached files are no problem since one can copy the folder where they are placed. More interesting would be a solution for creating sql script for importing into the target redmine datebase.

so any ideas?

regards
Matthias

I needed to do that with a project in my company. All I can say is that it is a really difficult task. I made some PDI transformations that migrate all tickets from one project in one instance to another instance. Obviously it ignores some info, is impossible to migrate everything without lost some data.

Main problems found:

• Ticket's ids will change, and all mentions using #NNNN notation will be broken.
• Categories, custom field, etc will be lost
• users on different instances can have different ids
• Redmine have a lot of references without FK

I've attached my .ktr a .kjb files, just in case someone want to adapt them. Steps to do:

1. Create a project on the target redmine
2. Learn PDI (former kettle) basics on the web if you don't know about it
3. Download all .ktr and .kjb files in the same directory
4. Open the files on spoon and try to understand what I did (I see if it is what you really want)
5. Change the database info to your databases
6. Check all table inputs for hardcoded data and change to match yours
7. Run temp.sql in some temp database and configure it on transformations
8. Run the .kjb file inside spoon

Be aware of:

• I ignored custom fields, categories and versions in migration. You'll need to improve the transformations of you want it.
• Users should exist in both redmine instances (can have different ids, the migration will be based on login)
• You'll need no move attachment physical files manually
• Trackers, statuses, priorities, etc should be the same in both instances
• Some journal info will be lost

I recommend you to run it on a test environment first and see what happens. DON'T RUN it directly on you production environment.

see also http://www.redmine.org/issues/3647