Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

MySQL code from Oracle.

hi,

As,

 MySQL community edition has No Packages to compatible with Oracle if Migrate from Oracle.
 MySQL community edition has  No PL/SQL stored procedures/functions to compatible with Oracle if Migrate from Oracle.
 MySQL community edition has No Sequences to compatible with Oracle if Migrate from Oracle.
 MySQL community edition has No Dynamic SQL to compatible with Oracle if Migrate from Oracle.

any work around on this ? can only rewrite, right?
Avatar of ste5an
ste5an
Flag of Germany image

??? Please rephrase your question..
While there might be a few objects created in MySQL that may work in Oracle, you better be prepared to re-create the objects Oracle would use for their purpose.
ASKER CERTIFIED SOLUTION
Avatar of awking00
awking00
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

ste5an,

We are considering the case where we need to migration oracle to MySQL, there are a lot of code need to convert, we are thinking any effort we should do to avoid it!

awking00,

" Objects written in Oracle would most likely need re-creation to work in MySQL."

most likely, we are considering to use ispirer for that! any one use this tools before, how accurate it is ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
tks.