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.
Hi,
I need Java ME SDK 3.2 for a project. I don't see on the downloads page, where can I still get it?
Thanks.
Guy
Hi Suresh,
Please find below the Oracle's answer to your question.
Postgresql to Oracle migration
Hope it helps.
Thanks,
Abhi
One more link that gives more details on how to approach this migration.
any migration tool for postgres to oracle? thanks!
Hi Abhi,
Thank you for your response.
Is Oracle SQL Developer tool suitable for this migration?
Please suggest which tool is best one for this migration?
Regards,
Suresh.
If you look at the links provided by Abhi to previous threads you will see that SQL*Developer doesn't currently support Postgres migrations. There are suggested alternatives in the referenced threads.
Mike
As per earlier threads, Oracle SQL developer doesn't support Postgres to Oracle migration hence you need to go for some other tool/approach as listed in my second reply.
such cross RDBMS migrations are done in 2 phases.
Phase 1- Code migration
Phase 2- data migration
In phase 1, you work on DDL conversion for all objects like- tables, views, triggers, procedures, packages, Mviews, in-built function conversion etc. This becomes complex when there is lot of code present since in many cases, you have to re-write the code to make it work in target RDBMS.
in phase 2, it is about migration of table data from source to target. It can be done by simply dumping the table data in CSV format and then using SQL loader kind of tool to load it.
You can also use replication tools like- Oracle Golden Gate and other tools available in market.
Ispirer - Migrate PostgreSQL to Oracle
http://www.swissql.com/products/datamigration/data-migration.html
Hi Mike,
Thank you for your reply.
Which one is the simplest and safest method for Postgres to Oracle migration?
Hi abhi,
Thank you so-much.
Can you please share more about migration using Golden Gate.