Exporting Mysql data to Oracle8i

Anon

Hello,
I have been looking at ways to export Mysql tables to Oracle.

The manual does not seem to offer much on this topic..

The table to be exported is huge and its data type should be preserved/mapped to Oracle without any data loss.

Thank you all for your time.

Regards,
Nagi

jburfield

I'm not aware of any way to export the table data along with the table description...

However...why not just create the table in Oracle as you need it, then just export the data from MySQL and import it into Oracle?

Might take a few extra minutes to do it this way, but it should work without a problem.

-- Jason

Anon

Hi Jason,
The database is huge and has very large tables.

By the what are the methods of exporting that you suggest ?

Is it like

select * from table TableA into outfile;

This might take a lot of time as the tables have millions of records.

Is there any other export method available in Mysql that can handle such huge tables?

Your help is greatly appreciated

Regards,
Nagi

Anon

hello,
Which version r u using?
If u r with SQL 7.0 or above then go for this,
Here we having a tool called DTS, Using that u can easy import data to SQL and also U can export data from SQL to other OLE-DB databases and ODBC databases and also to text format.
This was found in EM,

thanks,
venkat.

jburfield

Have you looked at the tool that Oracle has just for this purpose?

I have not used it, but I know they have created a piece of software solely for helping move from MySQL to Oracle.

You could do a select into outfile, however, you could also probably just do a dump.

mysqldump -u root -ppassword database_name > your_dumped_file.sql

That will dump table descriptions as well as the data. It is probably a bit faster than a select into outfile.

-- Jason