Its a small migration. -Satish
Stefan Hinz wrote: > 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 --------------------------------------------------------------------- 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