The simplest way to migrate databases from Oracle to MySQL
- Because the work needs to be the Oracle database to MySQL database, the data volume is large, millions other data, the table is more, there is a quick and secure method? The answer is yes, the following describes a tool, very easy to use
- Required Tools: Navicat Premium
Navicat Premium is originally charged, but there are a lot of green version (piracy), I test, also very useful, local tyrants can ignore this sentence.
The first step:
- Install Navicat Premium, open the software, establish a link to the database, one link to the original Oracle database, and the other is the MySQL database link.
Step Two:
- Click the Tools button on the menu bar, then point to the first "data transfer"
Step Three:
- In the Data Transfer dialog box that pops up, select the Oracle database you want to export and the MySQL database you want to import.
Fourth Step:
-click the Start button to start data transfer
-I exported this table has 150,000 data, the export completed also took 274 seconds, the speed is still possible
The simplest way to migrate databases from Oracle to MySQL
