Using Oracle instead of MySQL

[richarddavies]

I'm just wondering what would be involved in using Oracle instead of MySQL.

How much work would be involved in "porting" osCommerce to use Oracle? Has anyone tried using Oracle instead of MySQL?

[vasttech]

Never tried it, but it really should not be that difficult if you are familiar with PHP and SQL.

 

I would take an empty mySQL database for OSC and export each table to a SQL file.

Then I would go over to the Oracle database and run the SQL files to recreate all the necessary tables for OSC.

 

Then you can edit the database.php file to connect to an Oracle database instead of a mySQL one.

 

Those are the only changes I can think that you would have to make.

[project_aism]

Those are the only changes I can think that you would have to make.

 

Not quite, all mysql centric queries need to be changed also. You need to scan through each file that uses a database query and find these incompatibilities.

 

Obvious examples include the ?limit? keyword which is not available in Oracle and control logic used in the query those syntax would be different in Oracle.

 

I know of OSC fork that is currently having difficult time converting to postgresql let alone Oracle.

 

But again, why would you want to use OSC with Oracle?

[richarddavies]

Not quite, all mysql centric queries need to be changed also. You need to scan through each file that uses a database query and find these incompatibilities.

 

But again, why would you want to use OSC with Oracle?

Any idea how many MySQL specific queries there are? (i.e. Are we talking 5-10 or 50-100?)

 

I work for a large university. We already have Oracle and it's the only database that our IT dept. "supports". It would be very nice (and help us avoid some political battles) if we could get OSC to work with Oracle.