We have a SharePoint Prod 2007 (sp1, 32 bits) with SQL 2005 cluster.
We are going to upgrade SQL 2005 to SQL 2008 R2.
My questions are:
1. What is the best approach? I found some info in the article about upgrading to SharePoint 2010."Move the database to a host server that has a different name" section in http://technet.microsoft.com/en-us/library/dd622865%28office.12%29.aspx.
Is it what I should follow?
2. We do have lots of add-on and custom code. Do I need to check for SQL migration and upgrade if these work for 64 bits or I can wait to check when I need to upgrade WFE to 2010?
3. Do I need to upgrade Sharepoint from SP1 to SP2 before doing SQL upgrade? I know I need to do so before upgrading to 2010.
Thanks a lot!
If you get confused, listen to the music play...
View Complete Post