Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate Postgresql to Oracle

7c959dee-34e1-43d4-90e8-c40d6b888e21Feb 4 2016 — edited Feb 5 2016

Is there a free software to migrate a Postgresql database to an Oracle one ?

I need to migrate the schema (tables, views, sequence) and, most importantly, the stored procedures.

I tried to use the procedure described here:

https://www.youtube.com/watch?v=W1QaEHpNw6Y

With the Postgresql JDBC driver from here:

https://jdbc.postgresql.org/download.html

But i don't have the option "Migrate to Oracle".

By right-clicking on a table, i can select "Copy to Oracle" and it works. But i can't see any of my procedures, and so cannot copy them into oracle.

I know there are similar questions but they are old and maybe in 2016 there is a solution.

This post has been answered by Mkirtley-Oracle on Feb 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2016
Added on Feb 4 2016
4 comments
10,659 views