How to Export & Import HANA Table

In this article, we are going to use SAP HANA Studio to export and import HANA database table.

Export HANA Table

1. Launch the SAP HANA Studio and login to the database. We are login through the tenant database and using SAPABAP1 user (considering the authorization and database schema).

2. Right click on the Catalog and choose Export.

3. Type in the table that you want to export and click on Add. This will add the table to your left panel as selected catalog object. You can have multiple tables to export and for this example, we are exporting table DEVACCESS (SAPABAP1 schema). Click Next.

4. In the next screen, choose the Column Table Format, either CSV or BINARY. Select both Including data and Including dependencies for Export Catalog Objects. For output location, you can have them in the server or directly in your local computer / laptop directory. Click Next.

5. The export running now. If you have huge size of table, please run in background.

6. Go to the output location, you will see something like below,

Import HANA Table

1. Right click on the Catalog and click on Import.

2. Specify the catalog location where you exported earlier. Click Next.

3. Select the catalog object for import. It will automatically collect from the exported location from above step. Click Next.

4. Define the options for import selections (Including data, dependencies / to replace existing catalog objects). For huge table size, you can specify the number of parallel threads. Click Finish.

5. It’s done. You can confirm the catalog objects using the HANA query or from the transaction code SE16 on SAP application side.