I am just in the process of migrating a few sites from Oracle to MySQL. I had access to both servers and wrote a little PHP program that queried one and wrote to the other. I think that will be your best bet. Install a temporary Oracle server import the DMP file. I used a utility called TORA to extract the table schema from Oracle. Since some datatypes are different in Oracle and MySQL I saved the TORA dump (definition only) to a text file and cleaned it up. Added "auto_increment" fields since mysql does not have sequences and changed datatypes where needed.
Then I ran the text file against mysql to create the tables. >From there a PHP program that connects to both databases and reads a row from oracle. Does any needed changes and writes to MySQL. One thing that needed special processing was Dates. Since Oracle uses a different date string than MySQL. I think the best bet is to use the "SET NLS_LANG" feature of Oracle to set the date format to the same as MySQL so when you select a date you can send it directly to MySQL and it will understand. You can also use the TO_CHAR function in oracle to transform the date into the format you want. Hope this helps you out a little on your conversion. Serge. ----- Original Message ----- From: "Mike Townend" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 12, 2002 9:29 AM Subject: RE: Oracle .dmp to mySQL > We don't have access to the Oracle server :( > > So as to a project handover to the client they just gave them the dmp > file... > > Im currently downloading Oracle from the Oracle site but it's a major > download :( > > Ive found a util that attempts to get the information from the dmp files > but this is failing :( so was just putting a feeler out to see if anyone > else had done this... So far I can recreate the table structure but cant > extract the actual data from the file. > > TIA > > Mike > > -----Original Message----- > From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 12, 2002 14:17 > To: Mike Townend; [EMAIL PROTECTED] > Subject: Re: Oracle .dmp to mySQL > > > Hi Mike, > > I am not sure, but as I remember Microsoft SQLServer has Import/Export > utility (standard installation) that can import data from different > sources (Oracle?! why not). > > Best regards, > Mikhail. > > ----- Original Message ----- > From: "Mike Townend" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, August 12, 2002 3:09 PM > Subject: Oracle .dmp to mySQL > > > > Hi all, > > > > We have just recently inherited a web project from another company > > who's DB was Oracle 8. And as such they have provided us with an > > exported .dmp file of the database they were using... > > > > We are using mySQL as our DB backend... Does anyone know of any tools > > > that will allow me to import this file into mySQL (or maybe SQL Server > > > which we can then import to mySQL) > > > > MTIA > > > > Mike > > > > > > > > --------------------------------------------------------------------- > > 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
