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 on Team Foundation Server.

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

1. 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.

2. 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.

3. 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

1. Correct any issues outlined in the migration report for the previous migration.

2. 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.

3. Change the <QueryName> section in the configuration file to specify the new query name.

4. 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.

5. 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

Other Resources

After Migrating Work Items
CQConverter Command-Line Utility for ClearQuest Database Migration