Except I don't have any access whatsoever to the Oracle server... All I have is a flat dmp file on a CD which has all the data embedded into this file...
I have found a tool that will extract the table structure from this file... But will not extract the data Mike -----Original Message----- From: Tim Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 18:11 To: [EMAIL PROTECTED] Subject: RE: Oracle .dmp to mySQL 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 --------------------------------------------------------------------- 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
