Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Sap hana import and export data using command line

Former Member

on ‎2013 Jun 10 9:57 AM

0 Likes
7,015

Hi,


We want to import and export the data in sap hana database using command line syntax not from hana-studio.

Regards,

Gopal

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Ravi_Channe
Active Contributor
‎2013 Jun 10 3:59 PM

Hi Gopal,

You can use the EXPORT and IMPORT SQL statements from the command line HDBSQL.

Regards,

Ravi

Show replies
Show replies
Former Member
‎2013 Jun 20 6:26 AM
0 Likes

Hi Ravi,

"Thanks for your timely reply but I didn't find the response to be relevant to my requirement.

FYI  I am able to import single table but unable to import bulk data's using command prompt.

While exporting a database, 4 different of files(including control file) are created.

 

Would like to confirm if the functionality is this or is it possible to import multiple table data's or import database with a single command in command prompt."

Regards,

Gopalakrishnan.V

Ask a Question