Skip to Content

Import & Export SAP Hana Database Object in (Dev, Test & Production)

Greetings Everyone,

I want to know how can I import & export Database object (100 Stored Procedure, 50 Functions, 30 User Defined Table Type, 20 User Defined View) from One Database to another.

Thomas Jung, Ralph Oliveira, Jacob Tan, Maria Trinidad MARTINEZ GEA, Sergei Travkin, Yatsea Li can you please help / share your experience on this !!!

Thanks You.

Regards,

Rahul Jain

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 23, 2018 at 08:46 AM

    If they are design time objects, they should be transported via Delivery Unit (old repository) or MTAR (XSA/HDI). However for pure catalog objects you can use the EXPORT/IMPORT statement to move some content (mainly tables and their content).

    https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20da0bec751910148e69c9668ea3ccb8.html

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Thomas Sir,

      Thanks for your reply, Can you please tell one more thing when we export via Import & Export wizard by right click the objects, That option doesn't give the option to import it in our Desired Database.

      Is there any way to accomplish this !!!

      untitled.png (19.9 kB)
  • Dec 05, 2018 at 01:51 PM

    If you choose Import from the context menu, then you've already chosen the target system based upon where you trigger the context menu.

    Add comment
    10|10000 characters needed characters exceeded