locked
how to migrate oracle databse into mysql databse RRS feed

  • Question

  • User364480375 posted

    Hi

    guys

    Kindly suggest how to  migrate oracle database into MySQL database.I am new to migration field. So i don't know  what things are needed and how to proceed.

    I tried to search a lot on internet but not getting which tool i should use.

    maters suggest which tool or idea i should try.Frown

    Thursday, November 20, 2014 3:57 AM

Answers

All replies

  • User1508394307 posted

    I tried to search a lot on internet but not getting which tool i should use.

    This https://www.google.com/search?q=migrate+oracle+databse+into+mysql returns about 2 mln of results. First link leads to http://www.oracle.com/technetwork/database/migration/mysql-093223.html 

    Did you ever try it?

    Thursday, November 20, 2014 4:08 AM
  • User364480375 posted

    Smir

    i did the same thing as i have already mentioned  . but not getting proper tool. suggest me  1 gud tool if u ve any idea???

    Thursday, November 20, 2014 6:42 AM
  • User1508394307 posted

    well if you need a tool then search for a "tool" e.g. https://www.google.com/search?q=migrate+oracle+to+mysql+tool 

    Again, the first result gives an answer http://www.ispirer.com/products/oracle-to-mysql-migration 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 20, 2014 6:59 AM
  • User364480375 posted

    smir.here ques is which tool is better and best to use. Google will suggest alot.

    Thursday, November 20, 2014 9:41 AM
  • User269602965 posted

    I use Oracle not MySQL

    but I do recall seeing MySQL has an administrator kit with MIGRATION function

    and then all you need is the ODBC or JDBC connector driver

    to hook up to Oracle and move your schemas.

    So that may solve moving data, but perhaps roles and such will need manual rebuild

    and of course PL/SQL might need modification to accommodate differences in Oracle SQL/PLSQL and MySQL

    you may find some Oracle functions in use not supported by MYSQL or renamed.

    Friday, November 21, 2014 4:32 PM