https://community.qlik.com/t5/Talend-Studio/Migrate-from-Oracle-to-Postgres/m-p/2352748#M119086 <P>Hello, I'm new to Talend Studio.</P> <P>I need to migrate database from Oracle to Postgres.</P> <P>I used this blog :</P> <P><A href="https://guydavis.github.io/2016/06/12/oracle_to_postgres/" target="_blank" rel="noopener nofollow noopener noreferrer">https://guydavis.github.io/2016/06/12/oracle_to_postgres/</A></P> <P>which was very helpful.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="talend.png" style="width: 980px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M5Q3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150284i84E1AFAB8FE0958C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M5Q3.png" alt="0683p000009M5Q3.png" /></span></SPAN></P> <P>My questions are :</P> <P>- Is it posable with Talend Studio to extract table structure from Oracle table and transfer it to Postgres as shown in picture above?</P> <P>- Is it posable to transfer indexes , store procedures , triggers and other database objects?</P> <P>Thank you in advance&nbsp;</P> Sat, 16 Nov 2024 05:39:59 GMT Anonymous 2024-11-16T05:39:59Z https://community.qlik.com/t5/Talend-Studio/Migrate-from-Oracle-to-Postgres/m-p/2352748#M119086 <P>Hello, I'm new to Talend Studio.</P> <P>I need to migrate database from Oracle to Postgres.</P> <P>I used this blog :</P> <P><A href="https://guydavis.github.io/2016/06/12/oracle_to_postgres/" target="_blank" rel="noopener nofollow noopener noreferrer">https://guydavis.github.io/2016/06/12/oracle_to_postgres/</A></P> <P>which was very helpful.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="talend.png" style="width: 980px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M5Q3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150284i84E1AFAB8FE0958C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M5Q3.png" alt="0683p000009M5Q3.png" /></span></SPAN></P> <P>My questions are :</P> <P>- Is it posable with Talend Studio to extract table structure from Oracle table and transfer it to Postgres as shown in picture above?</P> <P>- Is it posable to transfer indexes , store procedures , triggers and other database objects?</P> <P>Thank you in advance&nbsp;</P> Sat, 16 Nov 2024 05:39:59 GMT https://community.qlik.com/t5/Talend-Studio/Migrate-from-Oracle-to-Postgres/m-p/2352748#M119086 Anonymous 2024-11-16T05:39:59Z https://community.qlik.com/t5/Talend-Studio/Migrate-from-Oracle-to-Postgres/m-p/2352749#M119087 <P>Talend is not the correct tool to build the structure of a database in Postgres based on a database in Oracle.</P><P>&nbsp;</P><P>I Googled "build postgres database from oracle" and found this Wiki which look like a good starting point:</P><P><A href="https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion" target="_blank" rel="nofollow noopener noreferrer">https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion</A></P> Thu, 06 Jun 2019 08:50:52 GMT https://community.qlik.com/t5/Talend-Studio/Migrate-from-Oracle-to-Postgres/m-p/2352749#M119087 nfz11 2019-06-06T08:50:52Z