Skip to Content
avatar image
Former Member

BW on HANA : system copy using export/import method

Hi Experts,

We are planning to perform BW on HANA homogeneous system copy using SWPM(export/import) method. However the source HANA DB is scaled out across 8 nodes and target DB is planned for only 3 nodes.

In this scenario, can you let us know if we need perform any specific preparations on target DB for the import process?

Does the import process looks for any specific DB configuration (no of nodes) on the target to match with source ?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 27, 2017 at 06:17 AM

    Hi Vihari,

    I assume you have already installed the target HANA DB as scale-out system, if you're using the standard export/import method, there's no additional preparation on target DB. Think about this, the SWPM tool doesn't know if you're going to using single HANA host or multi host for target system, so all things will be standardized.

    You may need to re-distribute the table or partition on the target HANA DB system after the import is done, I'm not sure if the SWPM will take care of it automatically.



    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      I am not sure that this question is already answered . .But..

      We need to match number of index server config in the target with source in the .ini parameters .

      1749467 – Copying SAP HANA From a Multiple- to a Single-Host



  • May 02, 2017 at 08:58 AM


    You can follow the Document - SAP First Guidance – Business Warehouse on SAP HANA Installation

    During the Import you will be asked for the Table Distributing again

    Best Regards Roland

    Add comment
    10|10000 characters needed characters exceeded