Migrating the Azure devops from one org to another org

[PElanchezhiyan]

Hello @MrHinsh ,

Currently, I'm working on migrating the code, boards, test cases, test plans, test suite etc from one organization to the another organization. I tried using the tool with the help of the youtube video which helped me a lot. However, the test cases, test plans with test suites are not migrating properly. Attached is the sample config file, that I have used. Please check and let me know what I'm missing in it. Also, I would like to know if you do have any latest video reference in order to use the latest release.

{
  "ChangeSetMappingFile": null,
  "Source": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/source/",
    "Project": "xxxx",
    "ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "AccessToken",
    "PersonalAccessToken": "xxxxxxxxxxxxx",
    "PersonalAccessTokenVariableName": "",
    "LanguageMaps": {
      "AreaPath": "Area",
      "IterationPath": "Iteration"
    }
  },
  "Target": {
    "$type": "TfsTeamProjectConfig",
    "Collection": "https://dev.azure.com/target/",
    "Project": "xxxxx",
    "ReflectedWorkItemIDFieldName": "Custom.ReflectedWorkItemId",
    "AllowCrossProjectLinking": false,
    "AuthenticationMode": "AccessToken",
    "PersonalAccessToken": "xxxxxxxxxxxxx",
    "PersonalAccessTokenVariableName": "",
    "LanguageMaps": {
      "AreaPath": "Area",
      "IterationPath": "Iteration"
    }
  },
  "FieldMaps": [ ],
  "GitRepoMapping": null,
  "LogLevel": "Debug",
  "CommonEnrichersConfig": null,
  "Processors": [
    {
      "$type": "WorkItemMigrationConfig",
      "Enabled": true,
      "ReplayRevisions": true,
      "PrefixProjectToNodes": false,
      "UpdateCreatedDate": false,
      "UpdateCreatedBy": false,
      "WIQLQueryBit": "",
      "WIQLOrderBit": "[System.ChangedDate] desc",
      "LinkMigration": false,
      "AttachmentMigration": true,
      "AttachmentWorkingPath": "c:\\temp\\WorkItemAttachmentWorkingFolder\\",
      "FixHtmlAttachmentLinks": true,
      "SkipToFinalRevisedWorkItemType": true,
      "WorkItemCreateRetryLimit": 5,
      "FilterWorkItemsThatAlreadyExistInTarget": true,
      "PauseAfterEachWorkItem": false,
      "AttachmentMaxSize": 480000000,
      "AttachRevisionHistory": false,
      "LinkMigrationSaveEachAsAdded": false,
      "GenerateMigrationComment": false,
      "WorkItemIDs": null,
      "MaxRevisions": 0,
      "UseCommonNodeStructureEnricherConfig": false,
      "NodeBasePaths": [],
      "AreaMaps": {},
      "IterationMaps": {},
      "MaxGracefulFailures": 5,
      "SkipRevisionWithInvalidIterationPath": false,
      "SkipRevisionWithInvalidAreaPath": false,
      "ShouldCreateMissingRevisionPaths": true
    },
	{
        "$type": "TestVariablesMigrationConfig",
        "Enabled": true,
      },
      {
        "$type": "TestConfigurationsMigrationConfig",
        "Enabled": true
      },
    {
      "$type": "TestPlansAndSuitesMigrationConfig",
      "Enabled": true,
      "PrefixProjectToNodes": false,
      "OnlyElementsWithTag": null,
      "TestPlanQueryBit": null,
      "RemoveAllLinks": false,
      "MigrationDelay": 0,
      "UseCommonNodeStructureEnricherConfig": false,
      "NodeBasePaths": [],
      "AreaMaps": null,
      "IterationMaps": null,
      "RemoveInvalidTestSuiteLinks": true,
      "FilterCompleted": false
    }
  ],
  "Version": "14.2",
  "workaroundForQuerySOAPBugEnabled": false,
  "WorkItemTypeDefinition": {
    "sourceWorkItemTypeName": "targetWorkItemTypeName"
  },
  "LinkMigration": {
    "Enabled": true,
    "SkipIfTargetWorkItemNotFound": true
 }
}

Video link used for reference: https://www.youtube.com/watch?v=Qt1Ywu_KLrc

[MrHinsh]

It looks like you are using a really old version of the tooling. We only support v16.1...

It looks like your WIQLQueryBit neglects to exclude Plans and Suits from the Work Item migration as it in the documentation and the defaults. We have a How-to: Migrating Plans and Suites. This is the same for v14 as is for the latest... but all the samples are not v16.x

[PElanchezhiyan]

Thanks for the clarification, @MrHinsh . Do I need to update the below query?
SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] NOT IN ('Test Case', 'Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] desc

If yes, I would like to import the test case, test suite, test plan etc as well? Can i modify the query as like below and update it?

SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @TeamProject AND [System.WorkItemType] IN ('Test Case', 'Test Suite', 'Test Plan','Shared Steps','Shared Parameter','Feedback Request') ORDER BY [System.ChangedDate] desc

Let me know your thoughts on it.

[PElanchezhiyan]

@MrHinsh, When i do this for migrating the test cases, I get the below error. Is this related to permission issue?

[21:23:52 ERR] [$v14.2.2] Unable to configure store
Microsoft.TeamFoundation.WorkItemTracking.Client.DeniedOrNotExistException: TF26198: The work item does not exist, or you do not have permission to access it.
at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem.LoadWorkItemFromRowSetInternal(Int32 rev, Nullable1 asof, IWorkItemRowSets witem) at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem..ctor(WorkItemStore store, Int32 id) at MigrationTools._EngineV1.Clients.TfsWorkItemMigrationClient.GetWorkItem(Int32 id) in D:\a\1\s\src\MigrationTools.Clients.AzureDevops.ObjectModel\_EngineV1\Clients\TfsWorkItemMigrationClient.cs:line 159 [21:23:52 FTL] [$v14.2.2] Error while running TestPlansAndSuitesMigrationContext Microsoft.TeamFoundation.WorkItemTracking.Client.DeniedOrNotExistException: TF26198: The work item does not exist, or you do not have permission to access it. at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem.LoadWorkItemFromRowSetInternal(Int32 rev, Nullable1 asof, IWorkItemRowSets witem)
at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem..ctor(WorkItemStore store, Int32 id)
at MigrationTools._EngineV1.Clients.TfsWorkItemMigrationClient.GetWorkItem(Int32 id) in D:\a\1\s\src\MigrationTools.Clients.AzureDevops.ObjectModel_EngineV1\Clients\TfsWorkItemMigrationClient.cs:line 174
at VstsSyncMigrator.Engine.TestPlansAndSuitesMigrationContext.FindTestPlan(TestManagementContext tmc, String name) in D:\a\1\s\src\VstsSyncMigrator.Core\Execution\MigrationContext\TestPlansAndSuitesMigrationContext.cs:line 628
at VstsSyncMigrator.Engine.TestPlansAndSuitesMigrationContext.ProcessTestPlan(ITestPlan sourcePlan) in D:\a\1\s\src\VstsSyncMigrator.Core\Execution\MigrationContext\TestPlansAndSuitesMigrationContext.cs:line 856
at VstsSyncMigrator.Engine.TestPlansAndSuitesMigrationContext.InternalExecute() in D:\a\1\s\src\VstsSyncMigrator.Core\Execution\MigrationContext\TestPlansAndSuitesMigrationContext.cs:line 128
at MigrationTools._EngineV1.Processors.MigrationProcessorBase.Execute() in D:\a\1\s\src\MigrationTools_EngineV1\Processors\MigrationProcessorBase.cs:line 47
[21:23:52 ERR] [$v14.2.2] TestPlansAndSuitesMigrationContext The Processor MigrationEngine entered the failed state...stopping run

[sathish-scantron]

Currently we are facing an issue in migrating the specific test suite from one Azure organization to another organization. Also we are using the latest version 16.1.0 . Please share the configuration.json file