Skip to Content
author's profile photo Former Member
Former Member

DB Migration from BW 7.4 MS SQL to BW7.5 HANA using SUM SPS17

Hi All,

I'm going to migrate DB from SQL to HANA using SUM DMO and I've couple questions because this my first migration.

1. I need to create stuck.xml file for DMO so I've connected BW7.4 SQL to Solman. Should I connect BW7.5 HANA to Solman as well in order to create stuck.xml? If so should I create two stuck.xml files or only one?

2. Should I install SUM in BW7.4 SQL or in BW7.5 HANA?

Thank you beforehand,



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 06, 2016 at 03:10 AM

    Hi Arman,

    As you may know, BW 7.5 on HANA only exists after SUM DMO.

    1. Only connect BW 7.4 on SQL to HANA and then generated stack.xml using MOPZ or maintenance planner.

    2. Extract SUM and register it in host agent on BW 7.4.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 10, 2016 at 08:58 PM

    The stack file is created based on the source system configuration and set up.

    The target system which WILL be on HANA and on NW 7.5 will be available only once the upgrade and migration is done using the DMO. So technically there should be only the source system and the stack file is generated based on it.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.