March 1st, 2003, 01:01 PM
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.
March 1st, 2003, 01:47 PM
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.
March 1st, 2003, 01:49 PM
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).