migrating MqSQL app to Oracle

Is there a guide that helps with migrating MySQL application to use Oracle database instead.

Apart from creating the database on an oracle database, how do I go about changing the coding (written in C++ on Unix Box) to use Oracle.

Rgds

This would depend on how you wrote your UNIX queries.

You'll probably need a differant connectin string to logon to Oracle. You'll need to name the ORA driver and log on info etc

Then if it's a straight string with variable information, let SQLPLUS do the work instead of trying to debug from your pgm. So copy the query to the SQL command line to check it (plug in a value that you know is valid for the variable part).

The MYSQL is pretty similar to Oracle so hopeuflly there'll only be a few changes.

Hope this helps.

-V

Opps. I didn't answer your question. I haven't seen any books like this. But my next post shows how I do it (and it's faster than shopping and reading a book).

-V