How to migrate data between oracle and mysql ?, Oracle MySQL migration?

How to migrate data between oracle and mysql ?, Oracle MySQL migration?

Recently, some of my friends have encountered some problems. How can oracle be converted to mysql? Today, I am here to teach you how to switch

First, you need to download a tool navicat premium. (If you don't have any friends, you can search and install it on your own)

1. Use navicat premium to connect to oracle. Since the software was used in the previous article, I will not be confused about how to configure it today.

2. Right-click the oracle database, select "Data Transmission", select the current database in mode, and select the database to be converted as the target. Because the oracle table names are in upper case, if you need to convert them to lower case, in advanced settings, select lower-case. After the settings are complete, click Start.

If you want to switch from mysql to oracle, the same operation is the same as above, but the source and target are the opposite. You must first select the mysql database.