RE: mysql to oracle

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Fri, 17 Mar 2006 08:38:52 -0000
Message-ID: <0A0E50CC00E3DB41A1B41739B9BD31C6AC2B46@MSAS-LDN90P.global.gam.com>

You won't create an Oracle database from a mysql dump file, Oracle DB's are very complex to setup compared to MySQL. You might be able to take mysql dump file and build a schema from it, the SQL code is essentially the same at a basic level. A warning, if you think you can simply take mysql application code and insert it into Oracle and run with it with no consideration for the design of either type of database, you will potentially crate a ticking DB time-bomb!

I don't know what experience you have of Oracle so apologies in advance if this seems obvious, but if you are new to Oracle I would suggest you familiarise yourself with basic schema concepts and how to get external data in and out of Oracle, all covered in the Oracle Concepts manual (available for free from otn.oracle.com).

Rgds

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Simone Saravalli Sent: 17 Mar 2006 7:41
To: oracle-l_at_freelists.org
Subject: mysql to oracle

Hi,

I have a mysql db and I made a dump with mysqldump in a text file (ex. mysql_dump.sql). I know that there's the way to use an existing text file to create a db with oracle using this sintax:

sql> @file_name.sql

The problem is that the sql file was created by mysqldump and its syntax is very different if compared with a sql file create, for example, with the expdp and impdp utilities provided by oracle. So, i'm looking for a tool capable to make a conversion of the sql file created with mysqldump in order to have a file that I can use to recreate the db under oracle. If possible I need an open source tool 'cause my db server runs linux (FC4).

Regards, Simone Saravalli
--

http://www.freelists.org/webpage/oracle-l

This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as an invitation or offer to buy or sell any securities or related financial instruments.
GAM operates in many jurisdictions and is regulated or licensed in those jurisdictions as required.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 17 2006 - 02:38:52 CST