December 9, 2003 at 10:11 am
Hi There,
Doing a data migration from an Oracle8 personal db system into SQL2K. All I have from the Oracle8 system is a system database backup(export.dmp)
Are there any utilities, 3rd party or otherwise, that might allow me to import this into SQL2K? Realize this is apples to oranges and the two wouldn't normally 'work and play' well together but I need to get the raw data out of the tables and the old pc it was on is dead without recourse.
Thanks,
Chris
December 10, 2003 at 10:04 am
I don't know of any utility that can translate the export file into SQL Server. As far as I know, an export file can only be read by the Oracle Import utility since the file is stored in Oracle-binary format.
Are you unable to import the data into another Oracle database? If you could do that, you could use DTS to import into SQL Server.
Hope this helps,
Greg
Greg
December 10, 2003 at 2:00 pm
heh, I've spent the last 7hrs trying to install and configure an Oracle9i personal edition database. Talk about fricken unfriendly app. You go into their 'enterprise manager', select backup restoration and it tells you that you cant do it from THAT problem and to go to the oracle management server. So I try to connect to that and it tells me it cant resolve the host name. Its MY machine, whats to resolve?!? *boggle*
Going out tonight to pick up an 'Oracle for Dummies' book.
I figured once I got things up I could use DTS but if there was a quicker utility I thought i'd give that a go.
Thanks,
Chris
December 10, 2003 at 3:14 pm
Oh man, I feel for you. Some of my longest days have been spent trying to configure Oracle.
Hope the book helps!
Greg
December 11, 2003 at 12:38 pm
why dont you use oracle imp utility
imp uid/passwd@db file=export.dmp
this will import all data from your file to oracle database
December 11, 2003 at 3:09 pm
Pakya is right on the mark. All you need is MSSQL2K DTS. (Data Transformation Services). No 3rd party required.
If you have a dump (export) of an Oracle database you can import that data dump to any Oracle server. Once you have the database imported to Oracle, connect to it from MSSQL2K DTS. I've done this dozens of times in the past and it works fine.
Regarding the Oracle9i config. Look at TNSnames file. I remember this as a source of trouble for configuration, its been a while since I was an Oracel DBA... wish I could help out with that more.
-Isaiah
-Isaiah
December 12, 2003 at 5:22 am
Kind of interesting...
When you connect are you able to import through DTS?
Mike
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply