Carrying out an ERP upgrade is complicated, unpredictable, and takes months. Such projects are often the cause of long faces in IT departments and – contrary to a commonly held perception – do involve risks in transferring data and switching between hardware. However, even a complex transition from SAP R/3 to the current SAP ERP 6.0 can go off without a hitch in your IT department.
Many new functions, a significantly improved process structure, and a reasonable price – the latest version of SAP ERP certainly isn’t short on qualities both large companies and smaller businesses in the up-and-coming midmarket can appreciate. For more, also check out “EHP: Keeping SAP Up to Date” and “Preview: EHP 5.”
Having attracted a number of attentive readers since its debut some days ago, this article series now turns its focus to the incremental progression of the software upgrade itself. Our aim is to allay any fears those interested might have about the transition and go through each of the primary steps in a practical setting. In case you missed them, here are the first two parts already published in this series:
The initial installment offers a rough overview of the complete software upgrade, and in the second we demonstrate how to install updates in an older SAP system and upgrade a SQL collation (database) – all while switching from a 32- to a 64-bit configuration.
In part three, we begin with the installation of SAP R/3 on a new server that will eventually become a productive system. We then import file backups from the previous SAP system before proceeding with the database upgrade from Microsoft SQL 2000 to 2005. The links directly below offer a quick run-through of these steps:
- Installing SAP R/3 4.7×200 on a new server
- Everything old is new again: importing a server backup
- Upgrading a database from MS SQL 2000 to 2005
Installing SAP R/3 4.7×200 on a new server
In the second part of this series, we first installed Windows Server 2003 x64 on a new server and configured of the initial settings. Even though we’re going to install SAP ERP 6.0 in a later step, the new system must first run the same software version as the old – in our case, SAP R/3 4.7×200. The initial step in doing so involves entering the transhost for the system with the following command:
For the x64 installation, the system variable JAVA_HOME should be set to JS2E, which is available for download on Sun’s Web site (direct link to download Java SDK: j2sdk1.4.2_17-x64)
In switching from a 32-bit Intel Xeon server to a 64-bit hardware system, it is crucial to install the x86-64 (AMD64) files; these can be found on the SAP master CD – which is available on a network drive at this point – in the following directory:
While the old server runs the 32-bit version of SAP R/3 and the 32-bit 6.40 NUC kernel, the new installation is based around the kernel’s 64-bit variant. The screenshot below displays the “sapinst.exe” file (located in the directory specified above) needed to begin the installation.
The installation process creates a login for the user (SAPServiceECP) and assigns it the permissions of the sysadmin role. The software installed can be checked by starting the program. Assuming everything works correctly, the data can then be mirrored from the old SAP system to the new server using the homogeneous system copy (HSC) method. The existing database is overwritten in the process!
Everything old is new again: importing a server backup
Upgrading a database from MS SQL 2000 to 2005