Tool usage: Transfers Oracle data to the Mysql database (Oracle database), and in turn transfers Mysql Data to the Oracle database (Mysql database ).
Attachment: http://download.csdn.net/detail/zou_hailin226/6320051
Tutorial (here is an example to copy data from the Oracle database on the server to Mysql on the local machine for reference only)
After installing the tool, create a mysql link, as shown in figure
Then create an Oracle connection, as shown in figure
Note that Oci needs to be set for connecting to the Oracle database. The second image below shows the setting method. Oci is in the instantclient_11_2 directory of the Oracle client directory or the installation directory of the Oracle database, of course, different versions may be different. You can search for oci directly. the dll file name is enough.
Now the connection between the two databases has been established, and the next step is to copy the data in the database. Right-click the database connection name you want to copy and select data transmission.
After completing the above operations, you can see the following interface. Refer to the above settings and click Start data to start synchronization. If there is a large amount of data, it may take a long time to wait!