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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2016

Added on Feb 4 2016

#database-and-application-migrations

4 comments

10,419 views