Dear Satish, > Thank you for your help.
Your welcome. > I used MyODBC 3.51, and successfully migrated to MySQL. Is this a MySQL user stories case, or just a small migration? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Satish Vohra" <[EMAIL PROTECTED]> To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 12:27 PM Subject: Re: Migration from Oracle Dear Stefan, Thank you for your help. I used MyODBC 3.51, and successfully migrated to MySQL. Regards Satish "Stefan Hinz, iConnect (Berlin)" wrote: > Dear Satish, > > > I want to migrate from Oracle to MySQL. > > So I need to import the tables and data from Oracle. > > Can anyone suggest any tool which can do this. > > Any pointer regarding this will be appreciated. > > (1) I am not familiar with Oracle, but I assume (oh, that word again) that > it has a dump utility to create SQL files (with CREATE TABLE / INSERT > statements). If it has, you can dump table definitions + data out of Oracle > and import them into MySQL like that (using the MySQL Monitor command line > client): > > shell> mysql < dump_from_oracle.sql > > In this case, it's fairly easy (and fast), but you will have to make sure > the Oracle column types (DECIMAL, NUMERIC, INT, CHAR etc.) in use are being > supported by MySQL. > > (2) Another way is to create the table definitions manually (choke!), export > the data from Oracle (SELECT ... INTO OUTFILE) and import them into MySQL > using LOAD DATA INFILE. > > (3) Yet another way is an ODBC connection from Oracle to MySQL, if Oracle > supports ODBC. ODBC is slow, but not as desperately slow as I sometimes > hear. As reported before on this list, I did a 1.2 million records import a > couple of days ago from MS Access into MySQL using MyODBC 3.51.04. Table > size was 500 MBytes, and it took 4 minutes on a 2 GHz machine running Win2K > (table create definition and import of all data). > > HTH, > -- > Stefan Hinz <[EMAIL PROTECTED]> > CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > ----- Original Message ----- > From: "Satish Vohra" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, December 11, 2002 5:12 PM > Subject: Migration from Oracle > > > Hi All, > > > > I want to migrate from Oracle to MySQL. > > So I need to import the tables and data from Oracle. > > Can anyone suggest any tool which can do this. > > Any pointer regarding this will be appreciated. > > > > Regards > > Satish > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php