How to Export/Import HANA table data.

[Former Member]

Hello,

I try EXPORT HANA table.

I try to export a table by using the HANA Studio on the client PC.

but does not work.

the following steps:

HANA Studio

<table> > Export > Select tables for export > Next >

Error message : "Choose a location"

There is the question

Export possible? HANA database table by using client PC(HANA Studio).

Best regards,

Hosoya

[Former Member]

Hello, Wolfgang, Rahul

thank you for reply.

I can not find an options (Export tables to current client.)

I'm using Revision 23.

Can not be done unless the Rev.24?

best regards,

Hosoya

[Former Member]

Hi Hosoya,

Which version of the HANA server/studio you are using? I checked in Revision 24 and was able to do the table export as follows:

Quick Launch>Export>SAP HANA Studio>Tables>'Select the server'>'Select the table'>Export table options

In Export Table options screen we can specify either the Server Location as 'Export Tables on Server' or to the client location

as 'Export tables to current client'

Note: The server and studio I use are on different servers.

Regards, Rahul

[Former Member]

Hello,

in the export dialog you have to options.

Export tables on server.

Export tables to current client.

If you choose "Export tables on server" you have to type the server path. Browse button is only enabled when Studio and server are on the same computer.

Regards, Wolfgang