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

[rahuljain257]

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, jacobtan, mariatrinidad.martinezgea, travkin, yatsea.li can you please help / share your experience on this !!!

Thanks You.

Regards,

Rahul Jain

[thomas_jung · Accepted solution]

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

[rahuljain257 · Accepted solution]

No sir it doesn't work in that fashion which you mentioned in your earlier post, please check my image.

I this example I tried to import all these procedure in my "AISATS_DEV_05122018" database but it actually getting imported into the "AISATS_DEV" database.

So I am confused why its happening like this !!!

Image 1

Image 2

[rahuljain257 · Accepted solution]

Any thoughts on this !!! Anything I am doing different ?

[thomas_jung]

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/20da0bec751910148e69c9668e...

[rahuljain257]

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 !!!