Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2006
    Posts
    2

    Unanswered: Converting mySQL to Oracle, Possible?

    Hi Everyone

    I am not a developer or whatsoever, I have a website and somehow I have heard that how oracle's DB being the best in the market for DB solutions.
    Currently my classified site is running with PHP mySQL, I forsee that if there is like 50-100 concurrent users then it will slow loading time.

    These are some of things i was considering using, PHP/Oracle or PHP/J2EE/Oracle
    I would love to hear some expert opinion and answers for this matter.

    1. Is converting mySQL to Oracle difficult and costly?
    2. Which version of Oracle would be required to do web based db?
    3. Would Oracle improve efficiencies and security?
    4. PHP/Oracle vs J2EE/Oracle, Which one would be better for the job?

    Thank you all for your time, appreciate it.

    best regards
    James

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >1. Is converting mySQL to Oracle difficult and costly?

    Difficult & costly are relative terms; so it depends.
    Oracle does have an automated tool to convert from MYSQL to Oracle.

    >2. Which version of Oracle would be required to do web based db?

    Any supported version of Oracle will work.

    >3. Would Oracle improve efficiencies and security?

    Not to a significant amount.
    Both should/must be designed into the application.
    Both can be abused if done improperly.

    >4. PHP/Oracle vs J2EE/Oracle, Which one would be better for the job?

    Use the one you know best.
    IMO, J2EE would be "overkill", but then again I am not a big fan of Java.

    THT & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    there's an old saying: "one of the worst things you can do for performance is premature optimization"

    perhaps a corollary is "don't jump from one technology to another on the assumption that the one isn't going to be up to the task"

    if you don't know how to tune a mysql server for performance, chances are you will have even more trouble with oracle

    i'm not really an authority on tuning, though, so take my comments with a grain of salt
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    THT? should that not have been HTH?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2005
    Posts
    38
    Try this out for MySQL to Oracle migration :

    http://swissql.com/products/datamigr...load-form.html

  6. #6
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    > 2. Which version of Oracle would be required to do web based db?

    I'm guessing you would want the free one (Express Edition) unless you specifically need the enterprise features like partitioning.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The free one is nice, but it has an upper limit of 4 gigs of data. Depending on your site, this might be too slow. The next level of oracle is not free. The link to the info on it follows.

    http://oraclestore.oracle.com/OA_HTM...?section=15105
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jul 2006
    Posts
    2
    Thank You all for your comments~! appreciate it!

  9. #9
    Join Date
    Sep 2005
    Posts
    23
    The best DB is the one you know better!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •