There is a application out there that does this called SQLPorter made by Real Soft Studio (http://www.realsoftstudio.com). It might be worth the $$ if it saves you some time and hassle. It worked for me going from SQL Server 6.5 to MySQL 3.23.
Hope this helps, Tim ----- Original Message ----- Sent: Monday, August 12, 2002 1:06 PM > 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 > > > --------------------------------------------------------------------- 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