how to Migrate database from oracle to mysql..

Question

User364480375 posted

Hi

guys ,

kindly suggest.

Answer 1

User269602965 posted

http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation.html

Use ODBC to make connection to Oracle and copy tables with INSERT INTO SELECT * FROM TABLExxx via the ODBC connection.

Answer 2

User364663285 posted

Read

http://forums.mysql.com/read.php?61,576625,576625

Answer 3

User364480375 posted

wmec in this link ..only ques is mentioned...what abt ans???

Answer 4

User364663285 posted

You can further click the relevant answers to that.

Answer 5

User364480375 posted

wmec

at below of page .....i am getting.. ans but what is the exact tools for my requirement. suggest for oracle 9i

Answer 6

User364663285 posted

In my opinions:

• You can generate the relevant scripts like insert/update statement, in Mysql syntax, within Oracle DB.
• And then apply the scripts into Mysql DB.

Answer 7

User364480375 posted

i need tool that will do all the task wmec

Answer 8

User-271186128 posted

Hi mike4u,

DBConvert for Oracle and MySQL is a database conversion tool that accomplishes fast and accurate two-way migration from MySQL to Oracle server and in opposite direction. You could try to use it.

https://dbconvert.com/convert-oracle-to-mysql-pro.php

Best Regards,
Dillion

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Answer 9

User-1605524712 posted

I strongly suggest Full Convert by Spectral Core: https://www.spectralcore.com/fullconvert

It will work just fine.