LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 03-23-2006, 04:35 AM   #1
abdul_zu
Member
 
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 04:36 AM.
 
Old 03-23-2006, 09:11 PM   #2
paulsm4
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 09:28 PM.
 
  


Reply


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 04:31 AM
ORACLE to MySQL yussef Programming 5 06-16-2005 02:38 AM
what is good, mysql or oracle?? gajaykrishnan General 4 08-21-2004 02:11 PM
Oracle 9i R2 and MySQL 4.0.X support ravishankar Linux - Newbie 2 10-03-2003 09:47 PM
mySQL vs oracle 8/9i hamster Linux - Software 10 04-29-2003 08:55 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 04:13 PM.

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