Our migration to Team Foundation Server started a couple of months ago with the Source Control adoption. Another step that we performed was to transfer our Countersoft's Gemini bug-tracker projects to TFS Issue Tracking System.
I've been searching around for a tool that would perform the job automagically ;-) and found nothing but other inquiries on the subject without answers. So, I'm posting the code, which helped us migrate our projects. Hopefully someone else can benefit from it too and I can save some of your time up.
Well, there is no rocket science here, but the code, I believe, is easy to reuse. Several SQL queries get all the issue information (subject, history, comments, attachments and links) from your Gemini database. Then we create the work items for the respective type, title, description, area, priority (if applicable), state, assignee, attachments and links. We've put custom mapping everywhere so that one can add his/her own lists of Gemini issue types, categories, assignees, states, etc. since Gemini allows easy customization of each project. The issue comments are added into work item's history in the appropriate format.
Some details coming to my mind:
So how would one use that?
I've added comments here and there. Hope those help!
The code is available here.
I would like to thank Mr. Hrissimir Neikov (Telerik Reporting team) who got the idea, wrote the base part and helped improving the tool. As to me, well, this was just a great learning experience!