Received: (qmail 15240 invoked from network); 11 Nov 2009 09:15:58 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 11 Nov 2009 09:15:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8B1ACB92A7; Wed, 11 Nov 2009 10:15:44 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id MXr6i3PRJAhg; Wed, 11 Nov 2009 10:15:44 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65C29CB924D; Wed, 11 Nov 2009 10:15:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 11 Nov 2009 10:14:23 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B5D4CCB9192 for ; Wed, 11 Nov 2009 10:14:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ywJsWmsSoQiP for ; Wed, 11 Nov 2009 10:14:23 -0500 (EST) Received: from ranger.tigr.org (Ranger.TIGR.org [192.207.234.252]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82EF2CB8C8C for ; Wed, 11 Nov 2009 10:14:23 -0500 (EST) Received: from localhost (unknown [127.0.0.1]) by ranger.tigr.org (Postfix) with ESMTP id A768A400F9; Wed, 11 Nov 2009 15:14:22 +0000 (UTC) Received: from ranger.tigr.org ([127.0.0.1]) by localhost (ranger.tigr.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id WZDb7GbZGo84; Wed, 11 Nov 2009 10:14:22 -0500 (EST) Received: from EXCHANGE.TIGR.ORG (unknown [172.17.5.22]) by ranger.tigr.org (Postfix) with ESMTP id 6A033400E1; Wed, 11 Nov 2009 10:14:22 -0500 (EST) Received: from atirone-osx.jcvi.org ([172.17.133.142]) by EXCHANGE.TIGR.ORG with Microsoft SMTPSVC(6.0.3790.3959); Wed, 11 Nov 2009 10:14:21 -0500 Cc: Message-Id: <5CF15006-1260-4EBF-AB99-F4AC01C1B25B@jcvi.org> From: Angel Tirone To: JDunn@sefas.com In-Reply-To: <2F802216565E44489600A03F763219A875152A@mia.SEFASBRISTOL> Content-Type: multipart/alternative; boundary=Apple-Mail-373-472387715 Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: Export DDL and data to MYSQL Date: Wed, 11 Nov 2009 10:14:21 -0500 References: <2F802216565E44489600A03F763219A875152A@mia.SEFASBRISTOL> X-OriginalArrivalTime: 11 Nov 2009 15:14:21.0970 (UTC) FILETIME=[A5A50720:01CA62E1] X-archive-position: 22541 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: atirone@jcvi.org Precedence: normal Reply-to: atirone@jcvi.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --Apple-Mail-373-472387715 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit I've done it a couple of times this year using the MySQL Migration Toolkit. http://dev.mysql.com/downloads/gui-tools/5.0.html Angel Tirone Database Administrator III J Craig Venter Institute On Nov 11, 2009, at 5:37 AM, John Dunn wrote: > Does anyone have experience of exporting DDL and data from Oracle to > MYSQL? > > If so, what tools would you recommend? > > > John > > > > > --Apple-Mail-373-472387715 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I've done it a couple of times = this year using the MySQL Migration Toolkit.



<= /div>
Angel Tirone
Database Administrator = III
J = Craig Venter Institute
 =

On Nov 11, 2009, at 5:37 AM, John Dunn = wrote:

Does anyone have experience of exporting = DDL and data from Oracle to MYSQL?
 
If so, = what tools would you recommend?
 
 
John
 
 
 

 

=
 

= --Apple-Mail-373-472387715-- -- http://www.freelists.org/webpage/oracle-l