migrate multiple schema's tables from oracle to postgres schema

[Anonymous]

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

[TRF · Accepted solution]

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

[Anonymous]

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

[TRF]

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.