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/
Updated on: 2019-12-16T07:50:51+05:30

416 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements