How to automate Weekly Backup OF Hana Calculation Views on Server using Delivery Units in HANA SP12

[former_member565459]

I need to automate the backup of my calculation views on server using Delivery Units. Is this possbile in Hana SP12.

Can we create some cron script in Linux which runs weekly and creates backup for the calculation views at the server site.

Is this thing feasible in HANA ?

I tried something like this, but it doesn't work.

EXPORT "_SYS_BIC"."RA.Test.Test/CV_TEST_EXPORT_IMPORT" AS CSV INTO '/hana/shared' WITH REPLACE NO DEPENDENCIES THREADS 2 NO STATISTICS;

[lbreddemann]

This has been discussed here before - searching for these discussions may give you the answers you look for.

Also, you may want to be more specific about whether you want to “backup” your development artefacts or the result set of your calculation view.

[former_member565459]

Hello Lars, I don't want the resultset of the calculation view. I want the development artifacts only. So, that incase of deletion of any calculation view, I can restore it by importing the same from my server. I tried searching for the solution but couldn't find any valid solution. I could export this to the prescribed file location. But now I'm concerned about how to import the same in my package from the server. What should be the import statement for the same. Can we please help me out ?

EXPORT"_SYS_BIC"."RA.Test.Test/CV_TEST_EXPORT_IMPORT" AS CSV INTO '/hana/shared' WITH REPLACE NO DEPENDENCIES THREADS 2 NO STATISTICS;

[lbreddemann]

I would look into using the "regi.exe" tool (in the HDBCLIENT folder). You can use 'export deliveryUnit' to export an delivery unit.

As this is a command line tool you can schedule it.

Caveat: I haven't done this myself yet, so it's up to you to figure out the details.

Concerning your EXPORT command: with _SYS_BIC you're referencing the activated runtime objects and not your development artefacts.