Database to database migration - Postgresql

Highlighted
Four Stars

Database to database migration - Postgresql

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.

Twelve Stars

Re: Database to database migration - Postgresql

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Database to database migration - Postgresql

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

Twelve Stars

Re: Database to database migration - Postgresql

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog