将数据从 TFS 2008 迁移到已经运行的 TFS 2012 [英] migrate data from TFS 2008 to an already working TFS 2012

问题描述

我阅读了有关从 TFS 2008 到 2012 的升级过程的所有信息.

I read everything about the upgrade process from TFS 2008 to 2012.

但我的情况有点不同.我需要在不损坏 TFS 2012 数据的情况下将数据从 tfs 2008 (sqlserver 2003) 移动到 tfs 2012 (sqlserver 2008 R2).

but my situation is a bit diffrent. I need to move data from tfs 2008 (sqlserver 2003) to tfs 2012 (sqlserver 2008 R2) without damaging the TFS 2012 data.

最佳实践是什么?

添加一些问题:

我正在努力在不损坏任何数据的情况下尽可能谨慎.所以我有:1. 旧服务器 TFS 2008 和正在使用的 sqlserver 20052 带有 TFS 2012 和 sqlserver 2008 R2 的演示服务器，上面有一些集合和项目(这是我们拥有并正在使用的服务器的副本).

I am trying to be as cautious as possible without damaging any of the data. So I have: 1. old server TFS 2008 with sqlserver 2005 which is being used 2 demo server with TFS 2012 and sqlserver 2008 R2 with some collections and projects on it (this is a replica of a server we have and is being used as well).

主要目的是将所有数据传输到2012服务器，杀掉老机器.我所做的是从 sqlserver 2005 备份并将所有 tf​​s* db 恢复到演示服务器.TfsActivityLogging构建集成版本控制仓库TfsWorkItemTrackingTfsWorkItemTrackingAttachments

The main purpose is to transfer all data to the 2012 server and kill the old machine. what i did was to take a backup from the sqlserver 2005 and restore all the tfs* db's to the demo server . TfsActivityLogging TfsBuild TfsIntegration TfsVersionControl TfsWarehouse TfsWorkItemTracking TfsWorkItemTrackingAttachments

之后我在演示服务器上运行tfsconfig import".

Afterward I run "tfsconfig import" on the demo server.

TfsConfig 导入/SQLInstance:SQLSERVERNAME/CollectionName:DemoImportCollection/confirmed

TfsConfig Import /SQLInstance:SQLSERVERNAME /CollectionName:DemoImportCollection /confirmed

失败:

Creating temporary structures... (169 of 502)
[Info   @15:45:36.159] [2014-01-14 15:45:33Z][Error] TF400744: An error occurred while executing the following script: UpgradeTestResults_OrcasToDev10Beta1.sql. Failed batch starts on the line 613. Statement line: 23. Script line: 635. Error: 2627 Violation of PRIMARY KEY constraint 'PK__tmp_tbl___1786A43E234A136B'. Cannot insert duplicate key in object 'dbo.tmp_tbl_OrcasTestOutcomeLookUp'. The duplicate key value is (?«ƒ??????????????¢???????????ƒ). (169 of 502)
[Info   @15:45:36.159] [2014-01-14 15:45:34Z][Informational] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: TF400744: An error occurred while executing the following script: UpgradeTestResults_OrcasToDev10Beta1.sql. Failed batch starts on the line 613. Statement line: 23. Script line: 635. Error: 2627 Violation of PRIMARY KEY constraint 'PK__tmp_tbl___1786A43E234A136B'. Cannot insert duplicate key in object 'dbo.tmp_tbl_OrcasTestOutcomeLookUp'. The duplicate key value is (?«ƒ??????????????¢???????????ƒ).
   at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteScripts(List`1 scripts, SqlParameter[] sqlParameters, List`1 serviceVersions, Boolean acquireLock)
   at Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.ExecuteSql(String stepData, ServicingContext servicingContext)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext)
   at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation) (169 of 502)
[Warning@15:45:36.596] TF255185: Encountered a warning during operation. Message=[2014-01-14 15:45:34Z] Servicing step Upgrade Test Results failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsTestManagement).
[Info   @15:45:36.627] [2014-01-14 15:45:34Z] Servicing step Upgrade Test Results failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsTestManagement) (169 of 502)
[Info   @15:45:36.627] [2014-01-14 15:45:34Z][Informational] Removing item. Key: TargetRequestContext. (169 of 502)
[Info   @15:45:36.627] [2014-01-14 15:45:34Z][Informational] Clearing dictionary, removing all items. (169 of 502)
[Warning@15:45:36.659] TF255185: Encountered a warning during operation. Message=TF255271: The team project collection could not be created. The number of steps before the completion of project creation is: 502. The number of steps completed before the failure was 169..
[Warning@15:45:37.690] Warning Message: [2014-01-14 15:45:34Z] Servicing step Upgrade Test Results failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsTestManagement)
[Warning@15:45:37.690] 
[Warning@15:45:37.737] Warning Message: TF255271: The team project collection could not be created. The number of steps before the completion of project creation is: 502. The number of steps completed before the failure was 169.
[Warning@15:45:37.737] 

我怀疑这个问题的发生是由于数据库中的希伯来字符在临时导入表上转换为问号(?????")

I have a suspicion that this problem occur due to Hebrew characters in database which translate on the temp import tables as question marks ("?????")

感谢解决此问题的任何帮助或指导.

Appreciate any help or direction solving this issue.

问候

埃雷兹

推荐答案

在尝试了一切(没有接触到真正的数据)之后，我成功了.

After trying everything (without touching the real Data) I succeeded.

我决定将升级过程分成两个 2008-2010 和 2010-2012.

I decided to split the upgrade process to two 2008-2010 and 2010-2012.

1. 我将 2008 年的 TFS 数据库复制到了新的 SQLSERVER由 TFS 2012 使用
2. 我使用 TFS 2010 添加了另一个虚拟机
3. 我从 TFS 2010 运行升级向导，该向导可识别 2008 年复制的数据库
4. 结果是附加到 TFS 2010 的新集合
5. 我在 TFS 2012 上分离了该集合
6. 我运行了附加集合(TFS 2010 中的一个)，这升级了集合.

这个过程很顺利.

感谢大家的帮助

Erez.h

这篇关于将数据从 TFS 2008 迁移到已经运行的 TFS 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！