Taking backup of schema in SAP HANA

SAPSAP 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/
raja
Published on 27-Dec-2017 21:55:40
Advertisements