<div>
thank you, both answers were equivalent to what I was looking for.
</div>


thank you, both answers were equivalent to what I was looking for.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
<br />
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?<br />
<br />
I have been gathering information and it looks like as long as SharePoint 2007 is on SP1, it will support SQL2008 databases.<br />
<br />
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?<br />
<br />
Thank you.
</div>
</div>


Hi,

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?

Thank you.

Migrating SQL 2005 to 2008, SharePoint 2007 Databases, anyone done this?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.