<story><title>Ora2Pg – Oracle to PostgreSQL database schema converter</title><url>https://www.ora2pg.com/</url></story><parent_chain></parent_chain><comment><author>craigkerstiens</author><text>A few other really handy tools when migrating from Oracle to Postgres:&lt;p&gt;Orafce - An extension to bundle in Oracle functions -&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;orafce&amp;#x2F;orafce&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;orafce&amp;#x2F;orafce&lt;/a&gt;&lt;p&gt;OracleFDW - A foreign data wrapper to query directly into Oracle from Postgres - &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;laurenz&amp;#x2F;oracle_fdw&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;laurenz&amp;#x2F;oracle_fdw&lt;/a&gt;</text></comment>
<story><title>Ora2Pg – Oracle to PostgreSQL database schema converter</title><url>https://www.ora2pg.com/</url></story><parent_chain></parent_chain><comment><author>chousuke</author><text>I&amp;#x27;ve used this for migrating some applications. It worked well enough. In addition, the &amp;quot;orafce&amp;quot; extension was also useful in reducing required changes to the actual SQL queries the applications made.&lt;p&gt;In my case, the applications were relatively simple, but many of the queries used sequences explicitly, and the lack of a common syntax there was a slight pain point.</text></comment>