Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Steps to duplicate HANA database


Can someone assist with steps on how to export a HANA database for import on another existing HANA database?  I need to create a clone.

From HANA studio the SYSTEM user don't have access to the SAP schema. And If login to studio with the SAP schema owner, I get a "[258]: insufficient privilege: not authorized" message if I try to export my own schema.



There is no predefined HANA user that automatically has every privilege and all access to the data.

You can create such an import/export user, but it especially when it comes to object ownership this way of "system copy" will not deliver an identical copy.

The SAP system copy tools (e.g. SUM) use the SAP-schema logon to export/import data and only copy SAP<SID>-objects. For a SAP Netweaver system copy that would be my recommendation to go ahead.

Another pro-point for this approach is that the SUM tools are way better instrumented and task oriented than the bare-bone EXPORT/IMPORT tools.

For all practical matters there is no way to create a full SAP HANA export. At least core objects like the SAP HANA user management etc. won't be exported.

For the repository... I haven't tried it, but my guess would be that the import would lead to issues.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question