Migrating SQL 2005 to 2008, SharePoint 2007 Databases, anyone done this?
Posted on 2010-09-10
We plan to migrate our current SQL2005 server to SQL2008 SP1, part of my process is to ensure all our current applications that make use of 2005 are compatible.
I am having issues finding a clear answer on this or the process involved for migrating SharePoint 2007 databases to the new SQL Server. What is involved from a SharePoint perspective?
I have been gathering information and it looks like as long as SharePoint 2007 is on SP1, it will support SQL2008 databases.
How would I go along migrating this? Is it a mater of pointing the SharePoint to the new database server, or is there more steps involved?