Skip to content

Instantly share code, notes, and snippets.

@surjikal

surjikal/copy_database.sql

Created August 21, 2019 01:27
Show Gist options
  • Save surjikal/efade21dfbe7e66684fd303d657db29f to your computer and use it in GitHub Desktop.
Save surjikal/efade21dfbe7e66684fd303d657db29f to your computer and use it in GitHub Desktop.
Download ZIP
[Copy database SAP Hana] SQL command to create a copy database in SAP Hana #Hana
Raw
copy_database.sql
-- Default B1_SHF folder: /usr/sap/SAPBusinessOne/B1_SHF
-- Create a new backup
EXPORT "SBODEMOIE"."*" AS BINARY INTO '/usr/sap/NDB/HDB00/backup/data' WITH REPLACE THREADS 10;
-- Duplicate a database (but you need to create a backup before)
import "SBODEMOIE"."*" as binary from '/usr/sap/NDB/HDB00/backup/data' with ignore existing threads 10 rename schema "SBODEMOIE" to "DEMODB_1";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment