I want to pull a set of user stories from a SOURCE TFS instance and put them into a TARGET TFS instance using Excel. I know other people have done this!
我想从源TFS实例中提取一组用户故事，并使用Excel将它们放到一个目标TFS实例中。我知道其他人也这么做过!
However, once I download the stories into Excel, I cannot rebind the spreadsheet to the TARGET TFS instance. I keep getting the following:
但是，一旦我将这些故事下载到Excel中，我就不能将电子表格重新绑定到目标TFS实例。我一直得到以下信息:
"The reconnect operation failed because the team project collection you selected does not host the team project the document references."
“重新连接操作失败，因为您所选择的团队项目集合不承载团队项目的文档引用。”
And, I dont see a way to clear the ID for the story or edit the document project/server references.
而且，我也没有办法清除故事的ID或编辑文档项目/服务器引用。
Q: How do I Migrate User Stories From One TFS Server To Another In Excel?
问:如何在Excel中将用户故事从一个TFS服务器迁移到另一个TFS服务器?
This should be easy!
这应该很容易!
2 个解决方案
#1
1
You need to create another excel sheet with the same columns that is bound to the new TFS server.
您需要创建另一个与绑定到新的TFS服务器的相同列的excel表。
Then just copy and paste between them.
然后在它们之间复制粘贴。
#2
0
I think it would be easier to use the TFS API to read from one instance and copy them to another TFS instance. The following post provides an example:
我认为使用TFS API从一个实例读取并将它们复制到另一个TFS实例会更容易。下面的文章提供了一个例子:
https://blogs.msdn.microsoft.com/bryang/2011/09/07/copying-tfs-work-items/
https://blogs.msdn.microsoft.com/bryang/2011/09/07/copying-tfs-work-items/
#1
1
You need to create another excel sheet with the same columns that is bound to the new TFS server.
您需要创建另一个与绑定到新的TFS服务器的相同列的excel表。
Then just copy and paste between them.
然后在它们之间复制粘贴。
#2
0
I think it would be easier to use the TFS API to read from one instance and copy them to another TFS instance. The following post provides an example:
我认为使用TFS API从一个实例读取并将它们复制到另一个TFS实例会更容易。下面的文章提供了一个例子:
https://blogs.msdn.microsoft.com/bryang/2011/09/07/copying-tfs-work-items/
https://blogs.msdn.microsoft.com/bryang/2011/09/07/copying-tfs-work-items/