How to migrate data from MySQL to Oracle using SQL Loader tool
For example suppose we have a table "Orders" in MySQL running in Windows with the following structure
This table has some 1000 rows and we need to load these rows into a table in Oracle running under Linux O/s.
Here are the specs of both PC's
Source
Database : MySQL
Table Name: Orders
O/s: Windows
IP
Address:192.168.50.1
Target
Database: Oracle
Table Name: Orders (Doesn't exist)
O/s : Linux
IP Address: 192.168.50.132
To migrate the MySQL table we need to do the following
Step 1
First Export the rows from MySQL table to a CSV or any delimited file. To export the rows we can use HeidiSQL or any other similar tool
To export the rows to a CSV file using HeidiSQL ,
Open HeidiSQL tool in Source PC
Login to MySQL server by typing your username and password
Select the MySQL Database in which "Orders" table is residing from from Left Panel
Expand the database node and select Orders table in the left panel
Then on the right panel, click the on the "Data" tab to view the data from "Orders" table as shown in the picture below
Right Click on any column in the data grid and select "Export Grid Rows" option
You will see a Export Grid rows dialog window. In this window enter CSV file name as "test.csv" and select "Complete Rows" option and De-Select "Include Column Names" checkbox and click OK
