Skip to Content

Move complete schema from one HANA system to other HANA system

Hi All,

In one of our scenario, the client wants to de commission one HANA system but wants to move one of its schema as it is with everything beneath it i.e tables, procedures etc. to the new HANA system. Please share your thoughts over this if this scenario is possible or if is there an workaround .

Thanks!

Ankit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jun 28, 2016 at 06:23 AM

    Please, Follow Steps as below -

    a) Export SCHEMA "ABC" from HANA DB 1

    b) compressed the export

    c) copied (binary) from HSNA DB 1 to HANA DB2

    d) uncompressed the export

    e) Create Schema on HANA DB2 and run import .

    Thanks,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2016 at 12:38 PM

    Hi,

    If you have created schema and its dependent objects using hdbschema, hdbtable, hdbprocedure, Then you go for Delivery Unit Export and Import.

    If schema and Tables are created using SQL queries,

    Catalog Export / Import is One option.

    HALM - Hana Lifecycle Management is also one option for transports.

    Regards,

    Muthuram

    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.