faqts : Computers1 : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

5 of 26 people (19%) answered Yes
Recently 1 of 10 people (10%) answered Yes

Entry

Is there something to convert Oracle sql code to MySQL sql code?

Mar 18th, 2005 04:11
Ralf Heller, Bryce Holland,


There are two way that I know of.
1. Use Microsoft Access and make one ODBC connection to your ORACLE DB 
and a second one to your MySQL DB. Then you can drag & drop your data 
from one DB to the other.
2. Use a php script to Select the data in Oracle and then Insert it 
into your MySQL Database.