What configurations needed to Migrate sprints and all work item types?

[shivajiwagh]

I am able to migrate some of the work item types but not all. I am missing few bugs and work item types. Also, it did not migrate any sprints. It also missed bugs from backlog items. I guess something is wrong with the configurations.

I want default configurations to migrate All work items (All types), all Sprints, All Test Plans/Test cases and All Backlogs.

Used the following config file.

"ChangeSetMappingFile": null, "Source": { "$type": "TfsTeamProjectConfig", "Collection": "xxxxx, "Project": "Travelwatch", "ReflectedWorkItemIDFieldName": "ReflectedWorkItemId", "AllowCrossProjectLinking": false, "AuthenticationMode": "Prompt", "PersonalAccessToken": "", "PersonalAccessTokenVariableName": "", "LanguageMaps": { "AreaPath": "Area", "IterationPath": "Iteration" } }, "Target": { "$type": "TfsTeamProjectConfig", "Collection": "xxxx", "Project": "Travelwatch_V2", "ReflectedWorkItemIDFieldName": "ReflectedWorkItemId", "AllowCrossProjectLinking": false, "AuthenticationMode": "Prompt", "PersonalAccessToken": "", "PersonalAccessTokenVariableName": "", "LanguageMaps": { "AreaPath": "Area", "IterationPath": "Iteration" } }, "FieldMaps": [], "GitRepoMapping": null, "LogLevel": "Information", "CommonEnrichersConfig": null, "Processors": [ { "$type": "WorkItemMigrationConfig", "Enabled": true, "ReplayRevisions": true, "PrefixProjectToNodes": false, "UpdateCreatedDate": true, "UpdateCreatedBy": true, "WIQLQueryBit": "AND [Microsoft.VSTS.Common.ClosedDate] = '' AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request')", "WIQLOrderBit": "[System.ChangedDate] desc", "LinkMigration": true, "AttachmentMigration": true, "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\", "FixHtmlAttachmentLinks": false, "SkipToFinalRevisedWorkItemType": true, "WorkItemCreateRetryLimit": 5, "FilterWorkItemsThatAlreadyExistInTarget": true, "PauseAfterEachWorkItem": false, "AttachmentMaxSize": 480000000, "AttachRevisionHistory": false, "LinkMigrationSaveEachAsAdded": false, "GenerateMigrationComment": true, "WorkItemIDs": null, "MaxRevisions": 0, "NodeStructureEnricherEnabled": null, "UseCommonNodeStructureEnricherConfig": false, "NodeBasePaths": [], "BasePath":[], "AreaMaps": {}, "IterationMaps": {}, "MaxGracefulFailures": 0, "SkipRevisionWithInvalidIterationPath": false } ], "Version": "12.0", "workaroundForQuerySOAPBugEnabled": false, "WorkItemTypeDefinition": { "sourceWorkItemTypeName": "targetWorkItemTypeName" }, "Endpoints": { "InMemoryWorkItemEndpoints": [ { "Name": "Source", "EndpointEnrichers": null }, { "Name": "Target", "EndpointEnrichers": null } ] } }

[muhahaaa]

Hi @shivajiwagh, the default config only migrates work items which haven't been closed before (AND [Microsoft.VSTS.Common.ClosedDate] = ''). Please remove this part and start the migration again.
Your WIQLQueryBit should now look like this:
"WIQLQueryBit": "AND [System.WorkItemType] NOT IN ('Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request')"