mysql to Oracle

abdul_zu · 03-23-2006, 04:35 AM

Hi all,

I have very big project having more than 400 quiries with MySQL database using PHP language. Now we made plan to replace MySQL with Oracle, But our Oracle administrator told me that there is many differents betwen MySQL and Oracle Quiries and parameters.

So please could any one tell me how i can canvert MySQL quries and parameters into Oracle, Is there any such tools available for converting?

I will appricate for your kind of attentions.

Thank You
Abdul lateef

paulsm4 · 03-23-2006, 09:11 PM

For starters, don't even THINK about getting anything older than the current version (mySQL 5.0). At least not if you want views, subselects, ANSI join syntax, or any of a zillion other things that have long been "standard" in Oracle, DB2 or SQL-Server.

Next, count the number of lines of PL/SQL code you have. It all needs to be re-written.

If you have any C programs that use OCI, count those lines and consider it likely they'll need to be re-written, too.

That should give you a rough idea of where to start...