Results 1 to 8 of 8

Thread: MySql to Oracle

  1. #1
    Join Date
    Dec 2002
    Location
    Nepal
    Posts
    32

    Unanswered: MySql to Oracle

    Hi all,

    I have very big project having more than 400 quiries with MySQL database using PHP language. Now we made plan to replace MySQL with Oracle, But our Oracle administrator told me that there is many differents betwen MySQL and Oracle Quiries and parameters.

    So please could any one tell me how i can canvert MySQL quries and parameters into Oracle, Is there any such tools available for converting?

    I will appricate for your kind of attentions.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    There is no magic, effort-free way to do this. You need to get to know Oracle and find out about how things are done in Oracle, what the differences are.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Oracle has a free product to convert from a number of different databases to the oracle database. MySql is one of the supported databases.


    http://www.oracle.com/technology/tec...ion/index.html
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Mar 2006
    Posts
    2
    Hi,

    You can try out the SwisSQL's SQLOne Console 2.0 tool for the purpose. Its a SQL query conversion tool which converts queries from One dialect to another (In your case, from MySQL to Oracle). As mentioned in the site, it is very particularly useful for DBAs and developers who work with multiple databases, as they need not spend unproductive hours trying to learn the differences in SQL dialects.

    The tool is available here..

    http://www.swissql.com/products/sql-...converter.html

    Regards,
    Vignesh.A
    http://www.swissql.com
    Automated Database Migration Solution
    Last edited by avignesh; 03-24-06 at 04:24.

  5. #5
    Join Date
    May 2004
    Posts
    29
    Quote Originally Posted by beilstwh
    Oracle has a free product to convert from a number of different databases to the oracle database. MySql is one of the supported databases.

    http://www.oracle.com/technology/tec...ion/index.html
    Would you please to tell me how to connect it? I've downloaded the Oracle Workbench and MySQL -plug-in and installed them on my PC, but couldn't make them talk to each other. On the capture wizzard 1 step 4 - Source Database Detail, I put the host name, password and port in when I click Next it didn't work. It asked to make sure the hostname, password and port are corrected. But they are corrected.

    Do I need to install Oracle workbench and plug-in on the same server of MySQL?

    Thanks for your help.

    BV

  6. #6
    Join Date
    May 2004
    Posts
    29
    Quote Originally Posted by avignesh
    Hi,

    You can try out the SwisSQL's SQLOne Console 2.0 tool for the purpose. Its a SQL query conversion tool which converts queries from One dialect to another (In your case, from MySQL to Oracle). As mentioned in the site, it is very particularly useful for DBAs and developers who work with multiple databases, as they need not spend unproductive hours trying to learn the differences in SQL dialects.

    The tool is available here..

    http://www.swissql.com/products/sql-...converter.html

    Regards,
    Vignesh.A
    http://www.swissql.com
    Automated Database Migration Solution

    how come I couldn't not configure the driver JDBC from SQLOne and/or Oracle Workbench... Is there a trick here? None of them work and all they complained about the username/password, drivername/connectionURL etc... Log back from Oracle and Mysql server... the password is fine.

    Can someone help me to configure those tools and make them run? Thanks so much...

    BV

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there a trick here?
    yes, you must be smarter than the equipment you are trying to use.
    Ready, Fire, Aim.
    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.

  8. #8
    Join Date
    Mar 2006
    Posts
    2
    Quote Originally Posted by bvo
    how come I couldn't not configure the driver JDBC from SQLOne and/or Oracle Workbench... Is there a trick here? None of them work and all they complained about the username/password, drivername/connectionURL etc... Log back from Oracle and Mysql server... the password is fine.

    Can someone help me to configure those tools and make them run? Thanks so much...

    BV
    As for as SwisSQL SQLOne is concerned, you can refer the subtitle Configuring JDBC Drivers in userguide.html, the help document present under the Product Installation Directory/help directory.

    Also you can mail the technical support team @ support [at] swissql [dot] com with the relevent details and they will guide you to resolve the issue at the best possible time.

Posting Permissions

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