copy data from one db to another DB

Anonymous — Wed, 15 May 2019 07:21:35 GMT

Hi Everyone,

I have to copy the data from one Redshift Table to another Redshift Table.

I used tredshiftrow->tredshiftInput->tredshiftOutput.

It is working but the data transfer is 67 rows/sec which is **bleep** slow.

i have around 4 million rows and this logic is taking forever.

I can not used tredhiftoutputbulkexe because i do not have S3.

Apart from that,i did all the things like setting 'Cursor size','commit every',taking the data to a file and then to transfer to TredshiftOutput Db but in every case speed is very slow.

Could you please let me know if there is any other method that i could try?

It would be very helpful.

Regards,

Mohit

Re: copy data from one db to another DB

fdenis — Wed, 15 May 2019 12:48:32 GMT

redshift is on cloud, so are you also running talend in cloud?
(speed depend of network capacities!)

topic Re: copy data from one db to another DB in Talend Studio

copy data from one db to another DB

Re: copy data from one db to another DB