Migrate from ClearQuest to Redmine - What am I missing?
Added by Rob D over 13 years ago
I am trying to migrate data from ClearQuest to redmine, and the basic process is as follows:
- 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.
- Parse the XML and generate SQL as per redmine schema, with data being inserted into issues and custom_values tables.
- Parse attachments txt & directory structure to generate SQL for the attachments table.
- Insert the sql into the redmine database with a simple
mysql database < file.sql
- Run a
db:migrate
- 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.