topic Re: migrate multiple schema's tables from oracle to postgres schema in Talend Studio

migrate multiple schema's tables from oracle to postgres schema

Anonymous — Sat, 16 Nov 2024 02:06:20 GMT

Hi All,

Can we migrate around 1000 tables which are in different schema in single database in oracle to postgres schema, which is created for these 1000 tables in talend 7.2

Thanks & Regards,

Ritu

Re: migrate multiple schema's tables from oracle to postgres schema

TRF — Sat, 20 Jun 2020 15:46:07 GMT

As the question is "can we" the answer is simply "yes we can".

Re: migrate multiple schema's tables from oracle to postgres schema

Anonymous — Sat, 20 Jun 2020 20:03:13 GMT

Hello TRF,

Thanx a lot . What approach should we follow as we have to create the structure as well in postgres using talend and each time table column will be different and also have multiple schemas in source .

Thanks in advance!!

Ritu

Re: migrate multiple schema's tables from oracle to postgres schema

TRF — Sun, 21 Jun 2020 08:13:09 GMT

Think the approach of dynamicaly build "create table" requests based on Oracle's USER_TAB_COLUMNS or ALL_TAB_COLUMNS content.
Then use tPostgresqlRow component to execute generated requests.