Migrate from Oracle to Postgres

[Anonymous]

Hello, I'm new to Talend Studio.

I need to migrate database from Oracle to Postgres.

I used this blog :

https://guydavis.github.io/2016/06/12/oracle_to_postgres/

which was very helpful.

My questions are :

- Is it posable with Talend Studio to extract table structure from Oracle table and transfer it to Postgres as shown in picture above?

- Is it posable to transfer indexes , store procedures , triggers and other database objects?

Thank you in advance 

[nfz11 · Accepted solution]

Talend is not the correct tool to build the structure of a database in Postgres based on a database in Oracle.

I Googled "build postgres database from oracle" and found this Wiki which look like a good starting point:

https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion