Skip to Main Content

Infrastructure Software

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.

Assigned User Profile / AD groups /

838745Feb 15 2011 — edited Apr 14 2011
I am new to SGD and trying to figuring out how to give permission to certain AD groups for certain applications.

I have two AD groups Info_Portal and Info_Survey and five applications let say App1, App2, App3 and App4. I would like App1 and App2 applications available to info_portal only and App3 and App4 available to Info_survy only.

I kind of got picture for assigne profile for applications but I am not clear how to created this new AD profile with in SGD.

Since I am new to SGD would prefer options through Admin console.

Thanks.

Habib.

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 May 12 2011
Added on Feb 15 2011
34 comments
1,276 views