Team Foundation Server 2008 Migration

Question

Hi,

We have 2 diffrent team Foundation server in our enviroment one is Team Foundation Server 2008 with SQL Server 2005 Enterprise X64 and second one is Team Foundation Server 2010 with SQL Server 2008 R2.

Now, I have to move Team Foundation Server 2008 Project to Team Foundation server 2010 with history and Source code.

Please help me out... 

Answer 1

Hi

Brian has a blog outlining how to migrate -http://blogs.msdn.com/b/bharry/archive/2009/10/21/upgrading-from-tfs-2005-2008-to-tfs-2010.aspx

Hope that helps...

Sid

---

Sid

Answer 2

Are those both TFS instances live?

---

Arun Sangal Software Configuration Management Denver USA

Answer 3

One solution that I have seen used:

1. Restore the 2008 instance to a temp 2008 instance. 

2. Then perform a 2008 -> 2010 upgrade on the temp 2008 instance created in step #1. 

3. From this newly created 2010 instance, use the TFS Integration Tools to perform a source migration between the newly created 2010 instance, and the current 2010 instance.

4. Remove the newly created 2010 instance because its only purpose was for the migration.

Note: TFS Integration Tools work great!!!

http://blogs.msdn.com/b/willy-peter_schaub/archive/2011/06/06/toc-tfs-integration-tools.aspx

Answer 4

Hi Rigel,

Thank you for your post.

If you want to move projects under TFS 2008 version control with history to TFS 2010.
You can try to use tfsconfig import command to import the data and projects from  TFS 2008 into a new team project collection in TFS 2010. Make sure that you back up all databases before you actually use the Import command. For detail imforamtion, you can refer to Import Command (TFSConfig).

Other similiar issues for you to refer:
http://social.msdn.microsoft.com/Forums/en-US/tfsintegration/thread/b5ab5a95-1621-4fcb-9693-213a6e540f3a
http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/8af7b517-1ddd-4c55-971b-9e9724819003

Another alternative is the TFS Integration Platform.

I hope this information will help resolve this issue.

If anything is unclear, please free feel to let me know.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 5

Hi,

I have already used Tfsconfig import but i got below error.

Please help me for the same...

Answer 6

Yes, both Server are live in the enviroment

In Tfs 2008 5 to 6 project and in Tfs 2010 20 to 25 projects

Rigel Networks

Answer 7

Please give me step by step information of TFS Integration Tools

I will try ......

Rigel Networks 

Answer 8

Hi Rigel,

Thank you for your response.

Is there any log relate to this issue in event viewer?
Would you please show us the detail move steps? They wil help narrow down the issue.

Best regards

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 9

There are not a singel error in event log....

Below is my following step

- First Of all i have ready TFS Server 2010 with SQL 2008 R2 Enterprise

- Backup Below database of TFS 2008 (SQL Server 2005 Enterprise)
 
 * TfsActivityLogging
 * TfsBuild
 * TfsIntegration
 * TfsVersionControl
 * TfsWarehouse
 * TfsWorkItemTracking
 * TfsWorkItemTrackingAttachments

- After that Restore the database on TFS 2010 SQL Server 2008 R2
- Now open a command prompt and change the path to “C:\Program Files\Microsoft Team Foundation Server 2010\Tools” and run the “import” command in  “tfsconfig”. command is below.
- TfsConfig import /sqlinstance:temptfs2012 /collectionName:imported2008 /confirmed
 

* sqlinstance - SQL Server 2008 R2 Instance
 * Collection Name - The name of the new Team Project Collection.
 * Confirmed -  Confirm that you have backed-up databases before importing.

Answer 10

Hi Rigel,

Thank you for response, from the information you provide, we still cannot narrow down the issue, would you please post the error log in tfs admintration console logs?

Do you enable tfs tracing? http://blogs.msdn.com/b/roberthorvick/archive/2009/10/27/enabling-tracing-during-tfs-2010-configuration.aspx

Best regards

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 11

Hi,

Below is the Tfs 2010 Server Error log

[Info   @10:46:39.691] Collection creation step 39 of 208
[Info   @10:46:39.691] [2012-03-12 10:46:37Z] Servicing step Create Integration Security Namespaces passed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework) (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z] Executing servicing step Upgrade Identities. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework) (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Step Performer: Framework (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Step Type:      UpgradeIdentities (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Step Data Text:  (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Retrieving target request context. (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Target request context has framework connection string: Data Source=newtfs2012;Initial Catalog=TfsIntegration;Integrated Security=True. (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:37Z][Informational] Upgrade Identities: Completed creating project scopes (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:38Z][Informational] Upgrade Identities: Completed creating groups (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:39Z][Error] TF50233: A cyclic group containment error occurred when adding a group member. The group [import2008project]\Project Collection Valid Users already has the group Team Leads as a contained member. (39 of 208)
[Info   @10:46:39.692] [2012-03-12 10:46:39Z][Informational] Microsoft.TeamFoundation.Framework.Server.AddMemberCyclicMembershipException: TF50233: A cyclic group containment error occurred when adding a group member. The group [import2008project]\Project Collection Valid Users already has the group Team Leads as a contained member.
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.IdentityComponent.AddIdentityToGroup(String groupSID, TeamFoundationIdentity member, DateTime sourceTimestamp, Boolean errorOnDuplicate, Boolean activate, Boolean& identifierChanged)
   at Microsoft.TeamFoundation.Framework.Server.IdentityComponent.AddIdentityToGroup(String groupSID, TeamFoundationIdentity member, DateTime sourceTimestamp, Boolean errorOnDuplicate, Boolean& identifierChanged)
   at Microsoft.TeamFoundation.Framework.Server.IdentityAttachHandler.AddMemberWithSyncOption(String groupSid, IdentityDescriptor descriptor)
   at Microsoft.TeamFoundation.Framework.Server.IdentityAttachHandler.Attach()
   at Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.UpgradeIdentities(String stepData, ServicingContext servicingContext, Boolean validateOnly)
   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, Boolean validateOnly) (39 of 208)
[Warning@10:46:39.698] TF255185: Encountered a warning during operation. Message=[2012-03-12 10:46:39Z] Servicing step Upgrade Identities failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework).
[Info   @10:46:39.698] [2012-03-12 10:46:39Z] Servicing step Upgrade Identities failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework) (39 of 208)
[Info   @10:46:39.698] [2012-03-12 10:46:39Z][Informational] Clearing dictionary, removing all items. (39 of 208)
[Warning@10:46:39.699] 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: 208. The number of steps completed before the failure was 39..
[Warning@10:46:39.743] Warning Message: [2012-03-12 10:46:39Z] Servicing step Upgrade Identities failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework)
[Warning@10:46:39.746] 
[Warning@10:46:39.746] Warning Message: TF255271: The team project collection could not be created. The number of steps before the completion of project creation is: 208. The number of steps completed before the failure was 39.
[Warning@10:46:39.747] 

Thanks & Regards,

Rigel Networks Pvt. Ltd.

Answer 12

Hi Rigel,

For TF50233: A cyclic group containment error occurred when adding a group member, you can refer to this link: http://connect.microsoft.com/VisualStudio/feedback/details/663816/tfs-2010-upgrade-tf50233-cyclic-group-continment-error, you can correct that swapping i.[sid] and N'S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3' is the fix. The next major version of our software will not have this issue when you import databases from 2005/2008.

Best Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 13

Hi Lily Wu,

I would like to know what do you mean by "The next major version of our software" ?

I have installed SQL 2008 R2 service pack 2 and tried again but I am getting the same issue at the same place.

I am stuck up at this issue since long. Please provide me the new version if available or else provide me step by step guidance to solve this issue as soon as possible.

Also I am not able to get the steps to execute the fix provided by you above. Where should I do swapping i.[sid] and N'S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3' ? Can you provide steps to achieve this?

Thanks,

Rigel Networks

Answer 14

Hi Lily Wu,

You did not respond to my above query but I have tried the steps but not yet succeeded. Below is the log when I run TFSImport command after running the query you suggested in the solution above. I have also attached screenshot of the process to run TFSImport command for your reference.

Please look into it and let me know if you want anything more.

[Info   @05:30:08.988] [2012-03-21 05:30:06Z][Informational] Data source: newtfs2012 (28 of 216)
[Info   @05:30:08.988] [2012-03-21 05:30:06Z][Informational] Database name: TfsIntegration (28 of 216)
[Info   @05:30:08.988] [2012-03-21 05:30:06Z][Error] prc_css_upgrade.sql Line 195
: Violation of PRIMARY KEY constraint 'PK_tbl_gss_group_membership'. Cannot insert duplicate key in object 'dbo.tbl_gss_group_membership'. The duplicate key value is (S-1-9-1551374245-1204400969-2402986413-2179408616-1-2272829225-1237020494-2565381641-1337725778, S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3). (28 of 216)
[Info   @05:30:08.988] [2012-03-21 05:30:06Z][Informational] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: prc_css_upgrade.sql Line 195 Error: Violation of PRIMARY KEY constraint 'PK_tbl_gss_group_membership'. Cannot insert duplicate key in object 'dbo.tbl_gss_group_membership'. The duplicate key value is (S-1-9-1551374245-1204400969-2402986413-2179408616-1-2272829225-1237020494-2565381641-1337725778, S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3). ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tbl_gss_group_membership'. Cannot insert duplicate key in object 'dbo.tbl_gss_group_membership'. The duplicate key value is (S-1-9-1551374245-1204400969-2402986413-2179408616-1-2272829225-1237020494-2565381641-1337725778, S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3).
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteNonQuery(Boolean bindReturnValue)
   at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(String sqlScriptResourceName, String[] lines, SqlParameter[] sqlParameters)
   --- End of inner exception stack trace ---
   at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(String sqlScriptResourceName, String[] lines, SqlParameter[] sqlParameters)
   at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(Stream sqlScriptResource, String sqlScriptResourceName, SqlParameter[] sqlParameters, Boolean retryIfLostConnection)
   at Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.ExecuteSql(String stepData, ServicingContext servicingContext, Boolean validateOnly)
   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, Boolean validateOnly) (28 of 216)
[Warning@05:30:08.994] TF255185: Encountered a warning during operation. Message=[2012-03-21 05:30:06Z] Servicing step Upgrade the Common Structure Service failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework).
[Info   @05:30:08.994] [2012-03-21 05:30:06Z] Servicing step Upgrade the Common Structure Service failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework) (28 of 216)
[Info   @05:30:08.995] [2012-03-21 05:30:06Z][Informational] Clearing dictionary, removing all items. (28 of 216)
[Warning@05:30:08.995] 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: 216. The number of steps completed before the failure was 28..
[Warning@05:30:09.039] Warning Message: [2012-03-21 05:30:06Z] Servicing step Upgrade the Common Structure Service failed. (ServicingOperation: UpgradePreTfs2010Databases; Step group: Upgrade.TfsFramework)
[Warning@05:30:09.040]
[Warning@05:30:09.040] Warning Message: TF255271: The team project collection could not be created. The number of steps before the completion of project creation is: 216. The number of steps completed before the failure was 28.
[Warning@05:30:09.041]

Answer 15

Hi Gigel,

On TFS admin console, is there a team project collection created by the command? If so, it maybe of incomplete shape.  Delete the newly created TFS database before you run the tfsconfig import command.

Did you install latest TFS 2010 SP1 cumulative update 1?  Previous cumulative update has been updated by that: http://www.microsoft.com/download/en/details.aspx?id=26211

Besides, GMCOLLINS replied above is a viable way. Which you can try if above solution doesn't resolve the issue.  Remember to backup TFS database before you upgrade or migrate.

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 16

Hi ,

I am suffering from the same issue as Gigel. I have tried to upgrade my TFS instance and recieve the same error 

[Error  @23:15:16.741] [2012-04-03 23:13:43Z][Error] TF50233: A cyclic group containment error occurred when adding a group member. The group [DefaultCollection]\Project Collection Valid Users already has the group Team Foundation Licensed Users as a contained member.

I tried to run the fix given in the other blog but it does not help, I recieve the same error as Gigel 

[Informational] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: prc_css_upgrade.sql Line 195 Error: Violation of PRIMARY KEY constraint 'PK_tbl_gss_group_membership'. Cannot insert duplicate key in object 'dbo.tbl_gss_group_membership'. The duplicate key value is (S-1-9-1551374245-1204400969-2402986413-2179408616-1-2272829225-1237020494-2565381641-1337725778, S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3).

I have tried both an inplace upgrade as well as migration both have the same errors.

In Place upgrade OS windows 2003, SQL Server 2008, TFS 2010, TFS 2010 SP1 and TFS 2010 hotfix VS10-KB2135068

Migration upgrade windows 2008, SQL Server 2008, TFS 2010, TFS 2010 SP1 and TFS 2010 hotfix VS10-KB2135068

My server is not part of a domain, it is part of a workgroup.

AnyHelp would be great.

Best Regards,

Stuart

Answer 17

Just want to bump this thread cause I have the exact same problem. In particular can anyone add a little context to the suggested solution "you can correct that swapping i.[sid] and N'S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-3' is the fix." 

Thanks

K