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?
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.