Thank you.
I have both Oracle client and MySQL client installed on my PC.
So I can sqlplus to connect to the Oracle database and mysql to connect to the MySQL database.
I also have Oracle developer, PlSQL developer and MySQL Workbench.
How do I actually copy one table from Oracle to MySQL? I have connection string details of both databases..
One way is to use Oracle dump file and then use that to upload to MySQL. Was wondering any simpler way.
For example, it is possible to do one time table copy from MySQL to Oracle via SQL developer front end. Was looking for just the reverse..
- from the 1st link i give above, it give you step by step to use odbc and using Navicat import wizard to import table from Oracle.
- alternatively you can export the table in Oracle to a text file/csv file using SQL Developer and import back to MySQL using Navicat import wizard. if i'm not mistaken, Workbench have the import feature too.
toooki
ASKER
Thank you.
I tried to use MySQL Workbench and yest there is an option but there seems to be restrictions. Some ssh needs to be running on the remote MySQL server ... but I don't have that much option.
Anyway I am a bit stuck with
LOAD DATA INFILE command to upload a record with one field as timestamp data type..
I read the steps but the instruction to download the "MySQL Toolkit" was not there anywhere -- may be all my fault.
Finally I downloaded "mysql-gui-tools-5.0-r17-win32.msi" via Google search. And installed the "MySQL Toolkit". It was easy to use and did the migration of a huge table from Oracle to MySQL very quickly.
Thanks.
http://www.dba-oracle.com/t_copy_oracle_table_mysql.htm