Syntax error Taking backup of schema in SAP HANA

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

424 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements