Migrate MySQL Data to Oracle

For project reasons, I tried to migrate the mysql database content to oracle tonight. Although the results failed, I learned a lot and it won't be necessary next time. Haha

Because the previous project used the mysql database, and now the new company requires oracle (the company is very large), it has to try to migrate the previous project.

After searching for relevant documents, oracle SQL developer is selected.

Tip: migrate Informix and DB2 databases to Oracle. For migration of all other databases, visit Oracle SQL Developer for migration.

The following documents are well written. Official: Oracle SQL Developer migration

Html> http://www.oracle.com/technology/global/cn/tech/migration/workbench/index_sqldev_omwb.html

This section describes how to migrate Microsoft Access, Microsoft SQL Server, and MySQL databases to Oracle.

If you are as lazy as I do, you can skip the text and go straight to the demo and Viewlet

You can try it. No need to find other tools.