moving to a new TFS in an other domain

Question

we want to move our TFS2008 to a new TFS2010 in an other domain. TFS2008 will die after successfully moved. The only thing we need to transfer are our projects and the check in history. What will be the best way?

Answer 1

If you want a full-fidelity migration of history and the TFS2008 (X) and TFS2010 (Y) servers are different server instances, I would recommend the following:

• Perform an in-place upgrade of the TFS2008 server (X) to TFS2010
• Move the Team Foundation Team Project Collection from server (X) to server (Y)

See Organizing Your Server with Team Project Collections for more information on team project collection management, as well as the Visual Studio ALM Rangers Team Foundation Server Upgrade Guidance.

The Team Foundation Server Integration Tools is another option, however, you must read the constraints in the Migration Guidance document which ships with the tooling.

---

[1] http://go.microsoft.com/fwlink/?LinkID=230948

Answer 2

Thank you, sounds good. While reading docu I could not find limitations between Server X = W2003 and Server Y = W2008R2. One diffreence is SQL Server x86 and x64, both are standard versions.

So will the move work?

 

 

Answer 3

If you stick to the same edition (Standard, Enterprise or Data Center) then there is no issue with moving from 32-bit to 64-bit. The constraints are moving from an edition that has more features, i.e. 32-bit Enterprise to 64-bit Standard would be a no-no.

Answer 4

 

I upgraded to TFS2010 without problems.

Moving the Collection database to another server in the new domain with TFS2010 installed (single server) worked.

Attatching the collection in TFS Admin ist not possible cause it's not listed as available database.

What went worng? Think there must be an additional step, securtity?

Hint: I took the backup file from our production server as I coud not stop the collection, might this be a problem?

I tried:
TFSConfig Accounts /ResetOwner /SQLInstance:TFS02 /DatabaseName:TFS_Test
and got:

TF30040: The database is not correctly configured. Contact your Team Foundation
Server administrator.
Log file:

[Error  @11:24:19.734] Microsoft.TeamFoundation.Framework.Server.DatabaseConfigurationException: TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'prc_QueryServiceHostProperties'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   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.HostManagementComponent.QueryServiceHostPropertiesBootstrap(Guid hostId, Boolean includeChildren)
   at Microsoft.TeamFoundation.Framework.Server.DatabaseConnectionValidator.ValidateApplicationConfiguration(String configConnectionString, Guid configInstanceId, List`1 sqlInstances, String analysisInstance, String analysisDatabaseName, Boolean ignoreAnalysisDatasourceUpdateErrors, Boolean autoFixConfiguration, Boolean fullValidation, DatabaseVerificationDatabaseTypes continueOnMissingDatabaseTypes)
   at Microsoft.TeamFoundation.Framework.Server.ApplicationServiceHost..ctor(Guid instanceId, String connectionString, String physicalDirectory, String plugInDirectory, String virtualDirectory, Boolean failOnInvalidConfiguration)
   at Microsoft.TeamFoundation.Admin.FrameworkFactory.CreateApplicationServiceHost(String applicationConnectionString)
   at Microsoft.TeamFoundation.Admin.FrameworkFactory.GetApplicationServiceHost(String applicationConnectionString)
   at Microsoft.TeamFoundation.Admin.AccountsActivity.ApplyCustomInputInspection()
   at Microsoft.TeamFoundation.Admin.Activity.ProcessInputs()
   at Microsoft.TeamFoundation.Configuration.CommandLine.ConfigurationCommand.RunActivity()
   at Microsoft.TeamFoundation.Configuration.CommandLine.CommandAccounts.ExecuteCommand()
   at Microsoft.TeamFoundation.Configuration.CommandLine.CommandAccounts.Run()

Please help!!!

Answer 5

Hi kph08,

I'e encountered the same issue.  Have you made any progress?

Cheers,

Nick

Answer 6

Hi Nick,

yes I did it following the described steps in msdn.

1. upgrade old TFS to TFS2010 SP1 on a Hyper-V clone

2. Backup the SQL Server collection

3. Stopped the collection

4. Backup the SQL Server collection again (this is my collection for the new server)

5. restored collection on new server

6. attached the collection

All I did wrong was stopping the collection and taking the backup after stopping. If you forgot it, it'll be better to restart.

Another way I tryed as well and worked, was importing a TFS2005 server to a new TFS2010 with the TFSCONFIG IMPORT command.

Hope ths helps.

Answer 7

Hi Kph08,

Thanks for getting back to me.

So just to clarify.  You received the error when using a sql backup that was taken prior to stopping the TFS collection on the source server?  And this was fixed if you stopped the TFS collection prior to taking the sql backup on the source server?

Cheers,

Nick

 

Answer 8

yes, but do a backup before you stop the collection. It already had situations where I could not start my collection again.