Migrate backlog items from TFS to DevOps

1. Read the page below: How-to migrate Backlog Items from TFS to DevOps

2. Go to TFS and find your project.

3. Click on Work > Queries > New > New Query

   

4. On Editor, add a filter:

   1. Work Item Type

      User Story, Bug

   2. State

      To Do,In Progress,Active,New,Pre-Acceptance,User-Acceptance

   

5. Save query as

   

6. Open a new Excel file, go to Team > New List

   

7. Click on Servers and add 2 servers, one for TFS connection and the other for DevOps connection

   

8. After that, select your TFS Connection > your project > Connect

   

9. In a query list, select your query created before and click on OK

   

10. Now, you can see a list of backlog items in TFS.

    

11. Go to DevOps > Boards > Queries > New query

    

12. Editor, add a filter:

    1. Iteration Path

       DSD-CIVAV Support

    2. Area Path (Use the name of the project being migrated)

       DSD-CIVAV Support\NASIMS

       

13. Save as

14. 

    Open a new Excel file, go to Team > New List and select your connection with DevOps

    

15. Select your query and click OK

    

16. Now you can see the list of your backlog items in DevOps

    

17. So, go in your first Excel file with the list of backlog items in TFS and copy all lines

    

18. Copy all lines in your second Excel file, with the list of backlog items in DevOps

    1. Change User Story to Product Backlog Item

       

    2. Change the User in Assigned To (if the user doesn’t exist in the list, you can remove the name)

       

    3. Change Pre-Acceptance or User-Acceptance in State to New

       

19. Go to TEAM > Publish

    

20. After this step, each items will have a new ID

    

21. Return to DevOps and go to Backlog > select DSD-CivAv Support Team and select all new backlog items imported

    

22. Droit button and Edit

    

23. Add the Area Path and Save

    

24. Each new backlog item was like Pre-Acceptance or User-Acceptance in TFS, we need to change the status: New to Commited and Save.

    

25. If you return in your query in DevOps, you can see all backlog items migrated and with the Area Path correctly.

    

NOTE: You don’t need to create a new query for each project, just change the Area Path in your actual query to the project that will be migrated and Save it.