cancel
Showing results for 
Search instead for 
Did you mean: 

SAP 4.6C on SQL 2005

Former Member
0 Kudos

Hi all,

We're doing migration planning for our production SAP instances from Informix over to SQL Server. We are currently running on 4.6c and we are looking to execute the platform migration (DB/OS) on that version and then upgrade to NW 2004S/ECC6. We're looking at the original MS white paper on running SAP on SQL Server 2005 (from Nov 2005) and it states that SQL Server 2005 is supported for WAS 6.x platforms (SAP 4.7 and above) but not for the older Basis architectures. Does anyone of that restriction has been subsequently lifted with the release of SQL Server 2005 SP1/SP2 or whether SQL 2005 still requires WAS 6.x as prerequisite. Looking to avoid another DB upgrade in the migration sequence if we can deploy 4.6c directly onto SQL Server 2005 as opposed to SQL Server 2000.

Thanks for the help.

RichP

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Richard,

R/3 4.6C is supported on SQL 2005 SP1 or SP2 as of Basis support pack 53.

You can review note 965145 Installation of 46C SAP Systems on MS SQL Server 2005

You will need to perform an OSDB Migration, which will involve exporting the data and structures out of your informix based system and importing the data into a Windows SQL system.

There are several options for doing this, including ways to combine an upgrade and a Unicode migration.

Please post back in this thread if you have any further questions.

Thanks

N.P.C

Answers (1)

Answers (1)

Former Member
0 Kudos

Excellent. Thanks much for the information. In reviewing the notes referenced, it appears that the 4.6 kernel will still be running the 32 bit version under WOW if running on an x64 SQL Server 2005 platform. Would you know if that be the case?

Former Member
0 Kudos

Hello Richard,

Your are 100% correct. There is no native x64 4.6D kernel. The only Windows 64 bit 4.6D kernel is the one from IA64 systems - a totally different architecture.

Let me know if you need any assistance locating a OSDB migration partner.

N.P.C

Former Member
0 Kudos

We did a successful migration last year from Informix to SQL Server 2000 using RealTech as our consulting partner and they did a super job. Our next steps are going to be a bit more challenging since we are looking at moving to ECC6 as well as 64 bit SQL Server 2005.

Any known challenges with running the 32 bit 4.6c kernel on SQL Server 2005 under WOW (performance?, stability?, scalibility?, memory consumption?, etc). It will be a transition step for us since our long term goal is to get to native 64 bit ECC6 on SQL Server 2005 after we consolidate the instances and move to Windows, however we may be in the transition state for some period of time.

Thanks again for the info.

RichP

Former Member
0 Kudos

>Any known challenges with running the 32 bit 4.6c kernel on SQL Server 2005 >under WOW (performance?, stability?, scalibility?, memory consumption?, etc).

all conclusions compare 32 Bit apps on 32 Bit OS to 32 Bit apps to 64 Bit os.

performance:

not for the 4.6C Kernel, but in general 32 Bit Programs are slightly better in terms of performance (2-5%) than their 64 Bit counterparts. This effect is related to the bigger pointers (64 Bit).

stability:

of the 32 Bit application itself, no difference compared to when running on the 32 Bit Operatings system. But if your application did hit virtual address space limits on the 32 Bit operating system, stability will increase on the 64 Bit OS. Virtual address space of 32 Bit SAP applications (except J2ee) is 4 GB on 64 Bit Operating System and 3 GB on the 32 Bit Operating System.

The operating system itself: 64 Bit Operating system is much more robust, because with the 32 Bit Systems you will more and more face situations where when using /3GB option the operating system itself run's in memory shortage situations (exhausted page/nonpage pools etc).

scalability:

better as you are going to use a 64 Bit database server. No AWE penulties, native 64 Bit support. The SAP apab server itself - no difference to 32 Bit.

memory consuptionn:

the application (SAP Kernel) no difference to 32 Bit OS.

4.6D 32 Bit kernel is released for productive use (not limited for update purposes) on the X(86_)64 operating system

regards

Peter