take a table dump

[Former Member]

we have been asked to take a table dump of M_CS_ALL_COLUMNS which has 400K records, would anyone suggest how to take the dump of the table records apart from studio.

Thank you

Jonu

[AtulKumarJain · Accepted solution]

Hi Jonu,

Please check, it will help you

https://help.sap.com/hana/html/sql_export.html

BR

Atul

[Former Member · Accepted solution]

thx much Atul

[lbreddemann]

What is this dump for?

Seriously: what is the purpose of this?

Assume you got the "dump" - now what?

Some of the columns wouldn't have been loaded when you took it,so you wouldn't even get useful numbers that way.

- Lars

[Former Member]

hi lars, the application team is doing a compression analysis of the SAP HANA tables and wants this info .

[lbreddemann]

That's why you actually don't want to export the table contents!

In order to figure out actual table sizes and compression factors, you want to use the script "memorySizing.py" that you can find in the pyhon folder of the HANA installation.

This will load the tables one after the other, eventually merge them (if you specify that), and create a proper report for the schema analysed.

Anyhow, you seem to have some idea on what you want to do with a dump of dynamic runtime data, so be happy with that approach...

- Lars