azure-devopstfstfs-migration

Change TFS Work Item Type In On Premises before Azure migration


I'm working on migrating TFS From On Premises to Azure Devops. We have few custom Work Item Types, and to create dryrun I had to remove them with witadmin. I'm aware of the fact that Change Item Type is only supported I Azure Devops.

Internet recommends creating clones, but due to a number faster way for me is to export as csv and import as different type.

Issue with both approaches is Work Item ID change.

The only way I see is doing change directly in db, and was wondering if anybody tried that before.

The table that looks like it may be the one is called tbl_WorkItemTemplateDefinition. Touching db is last resort.

Did anyone successfully changed work item types and kept same ids?


Solution

  • For future reference:

    Changing all custom work item types in [Tfs_DefaultCollection].[dbo].[tbl_WorkItemCoreLatest] to Task works.

    This doesn't update custom fields or anything like that, but it lets you keep work items with current id post migration.

    This is for XML type, with custom work item types that need to be removed to move from on premise tfs to Azure Devops.