Migrating from MySQL to Oracle)

Migrating from MySQL to Oracle)

If you use the keyword "MySQL migration to Oracle" to search online, the basic information you get is about how to migrate data from Oracle to MySQL, there is little information to migrate data from MySQL to Oracle.

Aside from the manual methods, you can find some third-party tools on the Internet to do this for free? I only found one, that is. If you use a silly method, consider this tool. Before this tool, Oracle provides a separate tool. In

Configure MySQL JDBC:

Note that you need to adjust the parameters during migration:

The rest is simple. configure it to different databases and prepare to store the Metadata database information. Then you can migrate the data. Do not go into details.

 

This method is just silly. Due to the limitation of the operating mechanism, the speed is not very good. There is nothing to do with the changed data generated during the migration process.