Help answer threads with 0 replies.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 03-23-2006, 05:35 AM   #1
Registered: Feb 2005
Posts: 71

Rep: Reputation: 15
mysql to Oracle

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

Last edited by abdul_zu; 03-23-2006 at 05:36 AM.
Old 03-23-2006, 10:11 PM   #2
LQ Guru
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
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...

Last edited by paulsm4; 03-23-2006 at 10:28 PM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Mysql Counters Oracle With A Purchase LXer Syndicated Linux News 0 02-21-2006 05:31 AM
ORACLE to MySQL yussef Programming 5 06-16-2005 03:38 AM
what is good, mysql or oracle?? gajaykrishnan General 4 08-21-2004 03:11 PM
Oracle 9i R2 and MySQL 4.0.X support ravishankar Linux - Newbie 2 10-03-2003 10:47 PM
mySQL vs oracle 8/9i hamster Linux - Software 10 04-29-2003 09:55 PM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 01:44 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration