SQL & PL/SQL

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.

Hi 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.

Regards,

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

Thanks,

Abhi

Hi Mike,

Thank you for your reply.

Which one is the simplest and safest method for  Postgres to Oracle migration?

Regards,

Suresh.

Hi abhi,

Thank you so-much.

Can you please share more about  migration using Golden Gate.

Regards,

Suresh.