SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability29
Upgrading from SQL Server 2000 to SQL Server 2005
Upgrading SQL Server 2000 to SQL Server 2005 does not require severe changes in the physical data structure. Typically, SAP products run with a 6.40 kernel, which is required to support SQL Server 2005. Check the SAP Product Support Matrix for more details10.
There are the two alternative methods of upgrading to SQL Server 2005:
Uninstall SQL Server 2000 and install SQL Server 2005. Then attach the SQL Server 2000 SAP databases to SQL Server 2005.
Install SQL Server 2005 in the same location without uninstalling SQL Server 2000.
Before uninstalling the SQL Server 2000 instance, verify that the SAP database is on code page cp850_BIN2. For more information, see SAP OSS Note 600027.
After the SQL Server 2000 database is attached to SQL Server 2005, a special version of SAP SAPINST needs to be run to adapt the database to some of the SQL Server 2005 features that are used by SAP. For more information, see SAP OSS Note 799058.
SQL Server 7.0 cannot be upgraded to SQL Server 2005 with SAP products. SAP products no longer support SQL Server 7.0.
Migration considerations for SAP products
Migrating SAP products from a non-SQL Server platform to a SQL Server 2005 platform is supported by SAP under these conditions:
SAP supports only the SAP Migration toolkit as the tool for migrating the SAP database schema and data from a non-SQL Server database to SQL Server 2005. No other tools are supported.
The migration is a complete data unload on the source system and a complete data load on the destination system.
Only objects including tables, views, and indexes that were created by using SAP object maintenance transactions are migrated. No objects that were created purely on the database are migrated; for example, an index that was created on the database is not migrated.
Typically, 3- to 4-terabyte data volumes can be migrated over a weekend according to companies such as RealTech, which specializes in migrations.
When assistance is needed, hire a consultant who is both SAP-certified and a Microsoft Certified Partner to perform the SAP migration.
10 The SAP Product Support Matrix is only available to registered customers of SAP AG.
Microsoft Corporation © 2005