Migrate backlog items from TFS to DevOps

Read the page below: How-to migrate Backlog Items from TFS to DevOps
Go to TFS and find your project.
Click on Work > Queries > New > New Query

On Editor, add a filter:

Work Item Type
```
User Story, Bug
```

State

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

Save query as
Open a new Excel file, go to Team > New List
Click on Servers and add 2 servers, one for TFS connection and the other for DevOps connection
After that, select your TFS Connection > your project > Connect
In a query list, select your query created before and click on OK
Now, you can see a list of backlog items in TFS.
Go to DevOps > Boards > Queries > New query
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
```
Save as
Open a new Excel file, go to Team > New List and select your connection with DevOps
Select your query and click OK
Now you can see the list of your backlog items in DevOps
So, go in your first Excel file with the list of backlog items in TFS and copy all lines
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
Go to TEAM > Publish
After this step, each items will have a new ID
Return to DevOps and go to Backlog > select DSD-CivAv Support Team and select all new backlog items imported
Droit button and Edit
Add the Area Path and Save
Each new backlog item was like Pre-Acceptance or User-Acceptance in TFS, we need to change the status: New to Commited and Save.
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.