Skip to Content
Former Member
Jul 08, 2011 at 03:49 PM

Upgrade SQL SERVER 2005 to 2008 with STM



I want to install a new Windows 2008R2 server / SQL Server 2008R2 and make homogeneous system copy to bring my database on this new server.

Source server : W2003 server / SQL server 2005 / SAP 4.7

Target server : W2008R2 server / SQL server 2008R2 / SAP 4.7 (temporary before ECC6 upgrade)

The database upgrade will be done normaly with the system copy step as OSS note 683447 - SAP Tools for MS SQL Server explains (detach/attach method).

Have you ever done this operation ? STM is it enough to upgrade from 2005 to 2008R2 ?

Thank you for your advice.