Content
Migrating to OpenProject
Started October 31, 2018 08:17 · 2 replies · 2 participants
I'm planning to migrate from another bug tracking tool (cvstrac) to OpenProject. Currently I'm developing a migration tool using the OpenProject v3 API.
Of course I want the ticket/workpackage numbers from the old system to remain the same in OpenProject (other resources in the enterprise are referring to these numbers).
How can I accomplish this? Any general ideas or thoughts about the migration process?
Thanks for your advice!
Hello,
What have you done for this process?
I ended up with the following process:
- First generate as many dummy workpackages via the API as there are tickets in the old bug tracking tool.
- Updating the dummy workpackages via the API with the data from the old bug tracking tool. E.g. setting the data from old ticket XY in the workpackage XY.
- During the update of the workpackages I also generate SQL statements which can be run directly on the OpenProject mysql database to set the author and the creation date of the workpackages. Thus I don't loose the original history.
Hope this helps.