Copy schema to another in Hana DB

You can get workfolder at backup console. Get destination folder and change backup as work for example.

[code language=”sql”]export “SOURCESCHEMA”.”*” as binary into ‘/workfolder’ with replace threads 10;[/code]

[code language=”sql”]import “SOURCESCHEMA”.”*” as binary from ‘/workfolder’ with rename schema “SOURCESCHEMA” to “TARGETSCHEMA”;[/code]

If you get privilege error like “SAP DBTech JDBC: [258]: insufficient privilege: Not authorized”, edit your user at Security menu and add EXPORT/IMPORT System Privileges.

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

This site uses Akismet to reduce spam. Learn how your comment data is processed.