Rebuilding HANA system & data migration

[former_member195421]

Hi Experts,

In my customer landscape , HANA has been implemented as a secondary database.

and some of the  performance critical transactions in ECC is communicating with HANA

Currently basis team wants to rebuilt the HANA system . I have some doubts here .

1. How we can migrate the catalog and content objects to the new system .

For content objects delivery units are assigned and we can download the objects and later import to new system , what about catalog objects .

Could you please advise.

Regards,

Ratheesh BS

[Former Member]

Hello Ratheesh,

If your catalog data is between 100-200 GB, you can export them to a local or NFS file system using export statement with parallel threads. Usually it takes 30 mins to export 100 GB of data if you run it with 10 parallel threads. After the system is built you can import the data.

export/Import statement:

EXPORT "Schema_name"."*" AS BINARY INTO 'file_system_location' WITH NO DEPENDENCIES THREADS 10;

IMPORT "schema_name"."*" AS BINARY FROM 'file_system_location' WITH REPLACE NO DEPENDENCIES THREADS 10;

If your system is quite big, then easiest way would be taking a backup and recovering from the backup once your system is built.

Thanks

Suresh