Physical machine to Hyper-V machine to physical machine

[Former Member]

We are running SAP 4.6 on Windows 2000 SP 4, etc. We want to upgrade to the latest SAP netweaver, on Server 2008 64 bit. Is the following a valid path.

Present SAP boxes to Hyper-v (2008 R2 flavor) VMs running Windows 2003 R2 64 bit (SAP 4.6), upgrade SQL to 2005. Do the SAP upgrade here. Then migrate the data/setup to a physical 2008 64 bit system.

Note: At no time would the VM's be used in production. They would simply be a waystation.

Thanks!

(And kudos to that Markus chap - I've read a number of your threads. Very useful!)

[Former Member]

Yes, my friend. As you know, kernel 640 is not supported on win2008 and 700 is not supported on win2000, so here there must be a win2003 as a transition platform for this upgrade+ migration, not to mention migration from 32bit to x64 is also involved.

1. Install a win2003 x64 server and SQL2000 32bit;

2. Install a new SAP instance same as your source system release in 32bit compatible mode;

note: if the system being migrated is BW, then be aware of that you might want to bring new features in SQL2008 of row compression and table partitions.

3. Detach the source DB from old SQL2000, and attach it to new SQL2000; some post configuration for DB copy will be required (STM tool). Now you've finish a migration from win2000 to win2003 32bit;

4. Start upgrading NW04 to 7.0, 640 to 700, find details in upgrade guide; Now you have your 700 instance on win2003 x64+SQL2000 32bit;

note: since release 701(700 EHP1) is available now, which you might want to upgrade instead of 700.

5. Change the collation 850BIN2 for SQL2000 32bit, detach DB;

6. Since migration from 32bit to x64 cannot be done smoothly, now you have to uninstall everything and reinstall win2003 and SQL2008 x64, followed by a new 700 or 701 instance;

7. Attach the source DB, post configuration for DB copy will be required (STM tool); Now you have your 700 or 701 instance on win2003 x64+SQL2008 x64;

8. Detach the SQL2008 DB;

9. Now go to your target win2008 OS, install SQL 2008 x64 and new 700 or 701 instance;

note: there might be some restrictions for NW 7.0 on win2008, go with the latest release (SR3 or newer).

10. Attach DB to this final OS/DB version: win2008 x64+SQL2008 x64, post configuration for DB copy will be required (STM tool).

[Former Member]

Should step 1 be Win 2003 32 bit, or 64 bit, with the SQL 2000 32 bit?

[Former Member]

> Should step 1 be Win 2003 32 bit, or 64 bit, with the SQL 2000 32 bit?

You need to install a 32bit instance in compatibility mode on a x64 Windows, SQL server 2000 32bit as well. It's listed as step 2 in previous reply.

Please find operation details in upgrade guide and note 960769.