#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    USA
    Posts
    1
    Rep Power
    0

    Question 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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    38
    Rep Power
    12
    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
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    38
    Rep Power
    12
    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

IMN logo majestic logo threadwatch logo seochat tools logo