Best way to Upgrade from Win2003/SQL2005 to Win 2008R2/SQL2008R2

[romeldavid_rodriguezdelac]

Hello

I already read about system copy to upgrade from Windows 2003 / SQL Server 2005 to Windows 2008R2 with SQL Server 2008R2

Also, I´ve read that I can make an "in-place Upgrade" , first do an In place upgrade to Windows 2008 R2 and then Upgrade to SQL Server 2008

But I have this questions.

1.- Whether I use "system Copy" method, Do I have to change my SAP GUI clients to new Server?

2.- Does the SID change or its the same as original?

3.- I have DEV, QA, and PRD, Which should be the first system I have to upgrade?

4.- After system copy on  the source, should I shutdown the server?

Because you are an experimented community, I really apreciate your comments

[romeldavid_rodriguezdelac · Accepted solution]

HI expert

What I did was you "in-place" upgrade from Windows 2003 x64 and later upgrade SQL server 2008 R2 with succed

thas was in a sandbox enviroment

now, with the real LandScape should I start with DEV?

[Reagan · Accepted solution]

now, with the real LandScape should I start with DEV?

Yes.

Follow this sequence.

D -> Q - > - P

Regards

RB

[sunny_pahuja2 · Accepted solution]

SAP does not support In Place upgrade. You would like to check SAP note 1476239.

Thanks,

Sunny

[Reagan · Accepted solution]

Hello

SAP does not support In Place upgrade. You would like to check SAP note 1476239.

This is not completely true. There are certain exceptions.

With certain restrictions, you can also perform a Windows "in-place upgrade" of an already installed SAP system without having to perform a system copy. With this in-place upgrade, you can directly migrate an SAP system from x64 Windows Server 2003 Standard or Enterprise Edition to Windows Server 2008 (R2), or from x64 Windows Server 2008 to Windows Server 2008 R2. For more information, see SAP note 1494740

1494740 - SAP system migration from Windows 2003 to 2008 (R2) 64-bit

Regards

RB

[sunny_pahuja2 · Accepted solution]

RB,

I had a discussion with owner of this note and this is not supported. SAP Note 1494740 is only for those people who know what they are doing and in case of issues, they can resolve it on their own.

Thanks,

Sunny

[Reagan · Accepted solution]

Sunny

The information you just provided should be in the SAP note to make people aware of it.

I would consider that as a warning sign had that been mentioned in the note.

Regards

RB

[sunny_pahuja2 · Accepted solution]

RB,

I do agree with you. It's kind of little confusion.

Thanks,

Sunny

[Reagan]

You may check these SAP notes

1476239  - SAP system migration to Windows 2008/2008 R2

151603  - Copying an SQL Server database

683447  - SAP Tools for MS SQL Server

If the source system is on 32 bit then check these SAP notes too.

666805  - MS SQL Server: Migrating from 32-bit to 64-bit

960769  - Windows: Migration from 32-bit to 64-bit (x86_64)

You can keep the same SID

You need to start with the DEV system, then the QUA and finally the PRD

Regards

RB

[former_member264034]

Hi,

Please check the pam for supported combinations.
ww.service.sap.com/pam

1076022   Release planning for Microsoft SQL Server 2008

547314 - FAQ: System Copy procedure

1476239  SAP system migration to Windows 2008/2008 R2

Regards,

Aidan