sap cloud platform - Dump HANA Database using "SAP HANA Web-based Development Workbench"

Question

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:

• the structure of the tables including primary and foreign key constraints
• the data inside the tables

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?

Answer 1

The export command seems relevant. The server will generate .sql files for structure and .csv for data.

If the database is a managed service such as HANA Cloud, you don't have access to the filesystem and should dump the files to an S3 bucket or an azure blob store.

Otherwise, just grab the files from the server box.