Skip to Main Content

Embedded Technologies

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.

JAVA ME SDK 3.2

gdillenSep 1 2014 — edited Oct 27 2014

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

Comments

abhinivesh.jain

Hi Suresh,

Please find below the Oracle's answer to your question.

Postgresql to Oracle migration

Hope it helps.

Thanks,

Abhi

abhinivesh.jain

One more link that gives more details on how to approach this migration.

any migration tool for postgres to oracle? thanks!

2928666

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.

Mkirtley-Oracle

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

abhinivesh.jain

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

2928666

Hi Mike,

Thank you for your reply.

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

Regards,

Suresh.

2928666

Hi abhi,

Thank you so-much.

Can you please share more about  migration using Golden Gate.

Regards,

Suresh.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 24 2014
Added on Sep 1 2014
7 comments
2,793 views