During the weekend I assisted a customer in the move of TFS 2010 databases from SQL 2005 to SQL 2008R2. The scenario also included Sharepoint Fundation 2010 and SQL Reporting Services.
MSDN offers a very complete guide about this procedure, http://msdn.microsoft.com/en-us/library/ms252516.aspx , however the guide warns about possible problems if the SQL Server version is different. The guide says:
“The version of SQL Server that you install must exactly match the version on the original server that hosted the databases. This requirement includes the service-pack level, the collation settings, and the language edition”
However there’s no guide or procedure to prepare the data to be upgraded or something like that. I guest this warning applies when moving from SQL 2005 to SQL 2005 in the case of disaster recovery but in the case of version upgrade there’s really no problem.
The other issue I had with the guide is that the link for the detailed procedure with Sharepoint after restoring the databases points to the article for WSS 3.0, my customer was using Sharepoint Foundation 2010. The procedure in this case consists on creating a SQL Server alias in the application server that hosts Sharepoint. If the server is 64 bits remember to create the alias for both clients, x86 and x64.