hanasap-cloud-platform

Dump HANA Database using "SAP HANA Web-based Development Workbench"


I'd like to get dump of a HANA DB using the browser based "SAP HANA Web-based Development Workbench". I'm especially interessted in exporting:

Once I log into the "SAP HANA Web-based Development Workbench", I'm able to open the "catalog" and execute SQL commands like e.g. SELECT * FROM MY_TABLE;. This allows me to download the data from one table as a CSV. But is there also something similar to pg_dump in postgres, a command that exports both table structure and data as for example a tar-compressed .sql file?


Solution

  • You can right click on the database which you would like to backup and select Export. Be sure to activate the checkbox Including data. I am not sure if it is also necessary to check the Including dependencies checkbox.

    You get a zip file which contains the sql-commands to create the tables and seperate data files which contains the content of the tables. Each table is saved in a seperate directory.

    export database in SAP HANA workbench