Hi. Is there a way to transparently translate MySQL queries to oracle back-end? I have an application written to use MySQL but I want data to be stored in oracle. Is there a way to avoid code modification and use Oracle as back-end database?
A:
If you don't have heavy MySQLed stored procedures or something like that that will tun only on MySQL, there is no problem in running SQL queries on Oracle.
Tomasz Kowalczyk
2010-09-13 11:37:24
OK. vBulletin as I know doesn't use any stored procedures. Are you sure that rewriting DB connection code will allow to use oracle as-is?
Dmytro Leonenko
2010-09-13 12:47:27
All DB engines conform to some SQL rules, and simple SELECTs, UPDATEs, DELETEs always will run on both.
Tomasz Kowalczyk
2010-09-13 13:03:00
Oracle doesn't recognize some MySQL specific syntax (such as the LIMIT clause) and treats empty strings as nulls.
Gary
2010-09-13 23:16:24