One team’s journey in their upgrading of their TFS from SQL Server 2005 to SQL Server 2008 (i.e. Something you may have to think about in your move to TFS2010)

Nullable Type - Migrating the TFS 2008 data tier from SQL Server 2005 to SQL Server 2008

“Team Foundation Server 2008 qualifies as a showcase of sorts for the Microsoft platform.  It builds on several core elements of the enterprise stack, including SQL Server, Sharepoint, and IIS.  This results in a product that can be difficult to deploy and even more difficult to modify once it is deployed.

Microsoft provides a guide that documents procedures for moving all or a subset of the components, as it should.  Unfortunately, the tremendous flexibility enjoyed in deployment means that covering all possible scenarios becomes a virtually impossible task.

I am currently responsible for the TFS deployment at a client that I would describe as being of middling complexity.  It evolved from a single server deployment to a multi-server deployment.  This deployment has been moved around several times during server reorganizations and survived the upgrade from TFS 2005 to 2008.

Recently, as part of a move from SQL Server 2005 to 2008, it once again became necessary to relocate the data tier.  Just to keep things exciting, this move took place between two instances installed on the same machine (a default instance of SQL Server 2005, and a named instance of SQL Server 2008).  We did not perform an in-place upgrade of SQL Server 2005.  I am going to detail the steps involved in this process, but first I will provide a little background.  I am going to assume you are on TFS 2008 SP1 and WSS 3.0 SP2.

…

…”

I’m very interested in what the final “TFS2008/SQL2005 to TFS2010/SQL2008 upgrade story” will be. I believe we have to move our TFS2008 to SQL 2008 ourselves prior, so have been keeping my eyes open for related articles…

(via Brian Harry - Upgrading a TFS 2008 Server from SQL 2005 to SQL 2008)

 

Related Past Post XRef:
27 pages of Team Foundation Server 2010 upgrade information from the team in the know, the Visual Studio ALM Rangers

Team Foundation Server 2010 installation, upgrade, information and more links
Planning for TFS 2010 (fka Rosario) – A picture says a thousand…
Preparing for Rosario – Think “less legacy” (no Office 2003, SharePoint 2 or SQL Server 2005)

“SQL Server 2008 Upgrade Technical Reference Guide” – 486 pages of SQL Server 2008 upgrade guidance