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