Project

General

Profile

Migrate from ClearQuest to Redmine - What am I missing?

Added by Rob D almost 13 years ago

I am trying to migrate data from ClearQuest to redmine, and the basic process is as follows:
  1. Export data from clearquest. I get XML of most data fields, a directory structure of attachments, and a proprietary format txt file for identifying attachments.
  2. Parse the XML and generate SQL as per redmine schema, with data being inserted into issues and custom_values tables.
  3. Parse attachments txt & directory structure to generate SQL for the attachments table.
  4. Insert the sql into the redmine database with a simple mysql database < file.sql
  5. Run a db:migrate
I am not a ruby/rails developer, so perhaps there is an easy way to do this with some kind of import rake script, but for now I am using perl with some hard-coded hashmaps for mappig projects, users and issue states etc. So, looking at the steps above, is there anything I am missing?
  • Do I need to add journal entries for all imported data?
  • Do I really have to run db:migrate?
  • Are there any other redmine (rake?) scripts I should be running after importing the SQL?

The conversion script and the sql are not my major issue, as initial import tests of basic data seem ok, but I am not sure what is required in the redmine back-end in order for everything to play nice.