topic Database to database migration - Postgresql in Talend Studio

Database to database migration - Postgresql

Anonymous — Sat, 16 Nov 2024 03:39:22 GMT

Hi All,

I am trying to do a migration from one postgresql DB to another postgresql DB using TOS. I have already tried it using the normal technique of db to db migration. But I would also like to know if its possible to use tRest component or tRestclient component to insert the data into the final DB. Currently I am trying to make the design which looks something like the attached figure but not able to progress as I am not sure what will coe in the HTTP Body in tRest component as I have data coming in from tMap already. Can someone please help.

Re: Database to database migration - Postgresql

fdenis — Wed, 08 Jan 2020 09:14:32 GMT

think aout quantity of data are you going to make one rest query by data ?
this process, is it one shot or not?

Re: Database to database migration - Postgresql

Anonymous — Wed, 08 Jan 2020 09:24:43 GMT

YEs, it will be one shot and one time migration.

Re: Database to database migration - Postgresql

fdenis — Wed, 08 Jan 2020 09:41:08 GMT

so think about dose it work or not!
you may not need to check speed. but check completion.