RE: MySQL conversion

 LeRoy,

        You might look at
http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp. Their tool, which is free if you don't need the advanced features that are available for the first 30 days free as well, should be able to help you port things from MySql to Oracle smoothly. You may have a problem or two with data types, but this is pretty smart when it comes to those as well.  

Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795 RGoulet_at_kanbay.com
: POWERING TRANSFORMATION
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LeRoy Kemnitz Sent: Monday, October 09, 2006 11:42 AM
To: Oracle-L Freelists
Subject: MySQL conversion

I just was asked about converting some MySQL databases to Oracle. I personally have never seen MySQL so I have no idea where to start with. Has anyone else done this? Can it be done? Can anyone point me to scripts to do it - if they exist? They are very small databases. If that is not easy, anyone point me to good docs on running it? I have been looking thru www.mysql.com but that doesn't tell me much.

LeRoy
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 09 2006 - 11:03:54 CDT