cancel
Showing results for 
Search instead for 
Did you mean: 

Has anyone upgraded sql 2005 to sql 2008 and win 2008 Netweaver 7.0, ECC 6?

MPGraziano
Participant
0 Kudos

We are currently running the following landscapes

Netweaver BI 7..0 on windows 2003 , sql 2005,

ECC 6.0 on windows 2003, sql 2005

SAP Portal 7 on windoes 2003 , sql 2005

And would like to plan the migration to windows 2008, sql 2008 IE 7.0

I just wanted to get some feedback regarding if someone has already done this and how you all went about to upgrade? Issues you encountered, things to avoid, all that good stuff

Without doing much research yet, and having just completed the migration from 32bit OS to 64bit and sql 2000 to sql 2005, I had to perform a NEW install of SAP on parallel servers , export from 32bit and import to 64bit servers

When we upgrade to windows 2008 and sql 2008, will we ALSO require to do a NEW install of SAP? just like what I just finished?

Please advise?

Regards & Thank You in Advance

Maria

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Maria

In addition to the above, also check the SAP Note 1294591 - Support SQL 2008 (DM)

The link may be informative:

[Removed by moderator.]

Regards

Chen

MPGraziano
Participant
0 Kudos

What about if we do an in place upgrade of SQL 2005 to SQL 2008 and remain on the same OS Windows 2003?

Will this be supported/certified? and what issues IF it is supported will I be faced with?

How complicated will it be to accomplish this?

Thanks

Maria

Former Member
0 Kudos

hi

SQL server 2008 is very well supported on Windows server 2003

Please refer http://msdn.microsoft.com/en-us/library/ms143506.aspx

Also refer to http://msdn.microsoft.com/en-us/library/bb677622.aspx for upgrading SQL server 2005

There will be no complications as such

Rohit

MPGraziano
Participant
0 Kudos

Thank You Rohit

Does anyone have more specific information regarding upgrade of SQL 2005 to 2008 for SAP?

SAP has it's own install thru the vbs file to install sql, and how will this work with ERP Kernel 7.0?

Maria

Former Member
0 Kudos

Hello Maria,

Refer to http://www.microsoft.com/sqlserver/2008/en/us/upgrade.aspx

Also you can refer to SAP guide for database upgrade to SQL server 2008 ,just go to the followng link

http://service.sap.com/instguides --> Other Documentation --> Database Upgrades --> MS SQL Server

Hope it helps

Rohit

MPGraziano
Participant
0 Kudos

Very good Rohit... I see the notes talk about critical bugs in SQL Server 2008 RTM, and we require to use Cumulative Update 2 (CU2) what does this mean?

maria

MPGraziano
Participant
0 Kudos

Also according to note 125970, Triggers on SAP tables

that generally SAP does not support any triggers on SAP ABAP appication tables in SQL Server

The custom code must be modified such a way that the affected row count is not written to the client. This is done by using

set nocount on

as the first command in the trigger.

I assume this will only effect only custom code... and not code delivered by SAP

Former Member
0 Kudos

Hi

There are some bugs in SQL server 2008 and for that there is package Cumulative update package 2 for SQL Server 2008 which you need to apply

Please refer to :

http://support.microsoft.com/kb/958186 for more detailed info

Rohit

Former Member
0 Kudos

and also you have given the wrong note number

Rohit

MPGraziano
Participant
0 Kudos

oops , sorry

Thanks

Answers (2)

Answers (2)

MPGraziano
Participant
0 Kudos

Cluster installed on our QAS & Production ECC and Portal

I installed ECC, while my collegue has assistance from consultant to complete portal.

Exceptional experience and learning !

thank you all!

Former Member
0 Kudos

Hello Maria,

we havent done the upgrade yet but yes we are planning for the same

if you want to go for it,refer to Note 1152240,it will be very helpful

Rohit