Has anybody done a database copy from HANA scale-up to a HANA scale-out (distributed system)?

[Former Member]

There is SAP procedure for doing the reverse from scale-out (ex. Prod) with M hosts to a HANA system with less hosts(m-n), but I have not seen a procedure for doing a database copy from a HANA single server system to a HANA scale-out on multiple hosts. Client needs to migrate both their Dev and QA instances which are on single servers (scale-up) to their new HANA scale-out system. Thanks.

[lbreddemann]

Hi John

Going from single-node to multi-node is not that difficult.

However, there is no automatic 1 to n node mapping.

The procedure therefore is:

• Copy the system 1 -> 1.
• Add the remaining nodes to the target system.
• Run a table-redistribution/re-partitioning to get the data over to the new nodes.

Not sure this is documented explicitly somewhere, but that's how I would approach this.

- Lars