How to transport a hana table with data in SP6

[Former Member]

Hi,

How to transport a database table in HANA with data from dev to test in SP6 ..?

regards,

Sri

[Former Member]

step1,in HANA studio,export table to dev hana server

export <table_name> as CSV into '/home/data/' with no dependencies threads 50;

step2, in DEV OS, compress folder /home/data

zip -r data.zip /home/data/

step3, in DEV OS,remote copy data.zip to TEST server

scp data.zip root@test_server:/home/

step4, in TEST server, unzip data.zip

unzip data.zip

step5, in studio, import table

import <table_name> from '/home/data' no dependencies threads 50;

[former_member186082]

Hi Sri,

Is the data volume huge in the table?

If not, simplest way is to export with data to local machine and import the same in target HANA system.

Regards,

Chandu.

[Former Member]

yes it has huge data - we had to transform this data and some manipulations on the source data - which do not want to do again - so looking for a solution where we can move the table with data.

[former_member186082]

Sri,

BODS can help you in that case, load from source HANA system to target HANA system and you can manipulate/cleanse/transform data in BODS.

Regards

Chandu