cancel
Showing results for 
Search instead for 
Did you mean: 

ECC 6.0 Upgrade (ECC 6 to ECC 6 EHP7 )

Former Member
0 Kudos

Hi Gurus,

I am in the process of implementing the upgrade project and would like to have your valuable inputs to achieve the completion of project.

Technical Details :

Source System : ECC 6 /NW SPS 9 with Kernel 700

OS : Windows 2003 & DB : MSSQL Server 2005

3 System Landscape

Target System : Upgrade to ECC 6 with EHP 7 ( Abap Stack)

New OS : Windows 2012 & New DB : MSSQL Server 2012

I have already gone through Recommended guides & Sap Notes/PAM where it mentions that we need to upgrade the OS /DB to either Windows 2008/2012/2014 and Sql 2008/2012/2014. I am also aware that NW SP patch level is one of the pre-requisite for the DB Upgrade.

In my current scenario , We are going with OS/SQL 2012, and one of the per-requiste as per the note 1651862 , NW Sp should be upgraded to SPS26.

My Approach will be as follows,

I will be using 2 Systems .as POC before stepping up into current landscape.

System A : - Build a system copy using production database same as source system in terms of SPS ,Kernel ,DB etc and perform SPS upgrade and take the patch level to SPS 26 .

System B : - New System will be with Windows 2012. Will perform  system copy using system A and then upgrade MS SQL Server 2005 to 2012.

Once done , will go for EHP7 direct Upgrade ( ECC 6 SPS 26 to ECC EHP7 SPS 11)

Please correct me ,if I am wrong with the above approach.

My real question ,

Can I Upgrade directly to EHP7 without NW SPS 26 Upgrade ( All in on single step). Below approach

1.System Copy using old production data on New Windows 2012.

2.Upgrade SQL Server from 2005 to 2012.

3.Direct Upgrade using SUM in one single shot NW SPS 26 , EHP 7 SP 11 & NW 7.4 .I am getting confused because I generated stack file from my solman system and it took all required upgrade stack . Attached screenshot.

If I go with above approach will it work or any issues will come during upgrade.

Please Note as per Sap note 1651862, you should first upgrade sps before upgrading sql server 2012 .

Regards

Asim

Accepted Solutions (1)

Accepted Solutions (1)

alichtenau
Advisor
Advisor
0 Kudos

Hi Asim,

you cannot directly upgrade to EHP7 without having the intermediate step to SPS26.
As there are some functions/prerequisites delivered with the packages they have to be implemented first. We often had these discussion and asked the development of SQL server and they confirmed that the SPS26 is mandatory before upgrading the database.

So your roadmap should be:

  1. Implement SPS26
  2. Upgrade OS/DB
  3. Upgrade SAP to EHP7


Cheers,
Andreas

Former Member
0 Kudos

Hi Andreas,

Thanks for the reply.

I understand that we need to have SPS26 but as per the note 1651862 you can upgrade the database before or immediately once upgraded to sql server 2012 and also solution manager has generated the stack xml file based on current system i.e. ERP SPS 27 as well so cant we go ahead in one shot.

Only intention to save time.

Regards

Asim

Answers (2)

Answers (2)

ahsanrizvi
Discoverer
0 Kudos

Hi Asim,

I am in a similar situation like you. I have to upgrade our ECC 6 to ECC 6 EHP7.

I am OK till Sandbox System, but how can we proceed in productive landscape. Do we have to perform same steps in DEV --> QAS --> PROD systems as well.

If you could help and suggest me the best approach to achieve this task successfully, I will be very thankful to you.

Regards

Ahsan

Reagan
Advisor
Advisor
0 Kudos

You will need to do a system copy as an in-place upgrade of Windows is not supported. You also need a supported OS and DB to update the system to EHP7.

So the solution for you is:

1 - Apply the required SPS

2 - Perform system copy using R3load export/import to the target OS/DB

3 - Plug the new system to Solution Manager and generate the stack file

4 - Upgrade the SAP system to EHP7


There is no need to perform a DB upgrade if you use R3load export import system copy as you can set up the target system with MSSQL 2012. You can also enable compression during this activity.

Former Member
0 Kudos

Hi Reagan,

Thanks for the reply ,

As I understand from your approach.

1- Apply the relevant SPS on current System.

2- Latest SWPM - Use System Copy Export/Import Method.

3- On New Windows 2012 Server ,Just  Install MS SQL Server 2012 and perform the system copy using Import Copy.

4-Once stack file is generated , we can directly upgrade in one single step i.e. from ECC 6.0 to ECC 6 EHP 7 .

Regards

Asim

Reagan
Advisor
Advisor
0 Kudos

Yes, and the stack should be generated only after the system is moved to the target server.

Former Member
0 Kudos

Yes , that I am aware of it . I got confused when you say system copy using R3load and that is used if there is change in OS or DB or for Unicode migration.

Just to be on same page , I can use the SWPM for System Copy Export/Import method ,in order to avoid DB upgrade at in later stages.

Regards

Asim

Reagan
Advisor
Advisor
0 Kudos

Yes. export/import is done by using the SWPM (sapinst) tool. You can use this method even if there is no change in OS and DB.

Former Member
0 Kudos

Thanks Reagan & it's clarified.

Let me try with this approach and get back ,if any.

Regards

Asim

Sriram2009
Active Contributor
0 Kudos

Hi Asim.


1- Apply the relevant SPS on current System.

2- Latest SWPM - Use System Copy Export/Import Method.

3- On New Windows 2012 Server ,Just  Install MS SQL Server 2012 and perform the system copy using Import Copy.

4-Once stack file is generated , we can directly upgrade in one single step i.e. from ECC 6.0 to ECC 6 EHP 7 .

1. In between Step 1 & 2 you have to upgrade the kernel to 7.21 with latest release, Windows 2012 supports the kernel 7.21. Kindly refer the SAP PAM support.sap.com/pam

2. In Step 1 & 4 you have to generate the stack file for SP and releae upgrades

3. During the target system import you can enable MS Sql DB compression at MS Sql db level.

BR

SS

alichtenau
Advisor
Advisor
0 Kudos

Reagan Benjamin wrote:

You will need to do a system copy as an in-place upgrade of Windows is not supported. You also need a supported OS and DB to update the system to EHP7.

So the solution for you is:

1 - Apply the required SPS

2 - Perform system copy using R3load export/import to the target OS/DB

3 - Plug the new system to Solution Manager and generate the stack file

4 - Upgrade the SAP system to EHP7


There is no need to perform a DB upgrade if you use R3load export import system copy as you can set up the target system with MSSQL 2012. You can also enable compression during this activity.

This approach is fine.
When I wrote "upgrade OS/DB" then I meant it in above way.

Former Member
0 Kudos

Hi Sriram,

Thanks for the reply.

Yes , I have already gone through the PAM and aware of kernel Upgrade.

Just want to confirm ,when you say dB compression - Is it for complete database or only large tables ?

Regards

Asim

Sriram2009
Active Contributor
0 Kudos

Hi Asim.

It is a full DB on MS Sql 2012. On MS Sql 2008 R2 you can select the page or row compression based on the SAP Note 1488135 - Database compression for SQL Server


BR

SS