Skip to Main Content

SQL & PL/SQL

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!

VB to PL/SQL Migration

User_FRTCMFeb 19 2014 — edited Feb 21 2014

Hi,

I have started now with a code migration project where the logics are written in VB. Briefly the architecture is Oracle (I/P) -> VB codes (Processing) -> MDB (O/P).

The Objective here is to migrate the codes from VB to PL/SQL & O/P will be passed to Oracle DB tables only.

As the project will be initiating in a week's time, I want to get any ideas/suggestions that you can share ?

How effectively can Oracle SQL Developer/ SQL* Loader/ Data Pump be a part of this ?

I also wanted to know an effective way of migrating table structures from MDB (Access 2003) to Oracle 11g database & if there are any tools to generate ER diagrams?

Thanks,

Mrinal (mridulmrinal@gmail.com)

This post has been answered by L-MachineGun on Feb 21 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2014
Added on Feb 19 2014
7 comments
557 views