Taking backup of schema in SAP HANA

It is always recommended to back up your critical systems.

Example

Following SQL command can be used to export schema in HANA:

EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH
   REPLACE;

This can also be directly zipped to Linux as below:

tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/

Govinda Sai

Updated on: 16-Dec-2019

238 Views

Kickstart Your Career

Get certified by completing the course

Get Started