How to: Migrate Work Items
After the analysis phase, the converter generates work item type definitions (WITDs) for each ClearQuest record type. For example, a file for the ClearQuest Defect record type is named Defect.xml. The converter generates a default work item form as a part of the schema generation during the analysis phase. However, this default form contains minimal formatting and is likely to require editing to achieve the work item layout that you want. For information about how to change the work item type definition file, see Customizing Work Item Types for Team Foundation.
After you have edited the work item layout, you are ready to migrate your work items from ClearQuest to Team Foundation work item tracking.
Required Permissions
To perform these procedures, you must be a member of the Service Accounts security group. For more information, see Team Foundation Server Permissions. Also, you must have the Super User permission for the ClearQuest database. For more information, see the ClearQuest Administrator's Guide.
Migrating the ClearQuest Work Items
To migrate work items
At the command prompt, run the following command:
**CQConverter.exe /c:migrate /m:CqConverterConfig.xml /s:**path\Schemamap.xml
Where path is the path of the schema map file. The schema map file is generated during the analysis phase in the specified output directory.
Note
The ClearQuest converter can take hours to run for large databases.
When the migration finishes, review the migration report for the status of migration and other issues if any; such as defects not migrating because of some field map inconsistencies.
The migration report is named CQMigrationReport.xml and is created in the folder from which you ran the ClearQuest converter.
Note
Since the converter converts all work items included in the query you specify, plus all work items that are linked to from those work items, the actual number of work items migrated may be different from the number of work items in the query.
If all the work items have not been migrated, you can run the conversion again after resolving issues outlined in the migration report.
To migrate more work items from ClearQuest to Team Foundation work item tracking, you can run the migration process again.
To run migration again on the same ClearQuest database
Correct any issues outlined in the migration report for the previous migration.
Make a query in ClearQuest that returns the desired work items, or run the same query if you only have to migrate work items that did not migrate the first time.
Change the <QueryName> section in the configuration file to specify the new query name.
Open the command prompt and type the command for migration:
**CQConverter.exe /c:migrate /m:CqConverterConfig.xml /s:**path\Schemamap.xml
The ClearQuest converter can take hours to run for large databases.
Note
For more information about ClearQuest Converter commands, see CQConverter Command-Line Utility for ClearQuest Database Migration.
When the migration finishes, review the migration report for the status of migration. The migration report is named CQMigrationReport.xml and is created in the folder from which you ran the ClearQuest converter.
See Also
Tasks
Walkthrough: Migrating ClearQuest Work Items to Team Foundation
Concepts
CQConverter Command-Line Utility for ClearQuest Database Migration