Oracle .DMP file to SQL Server 2000

Oracle .DMP file to SQL Server 2000

Post by PanDev Inc » Wed, 06 Mar 2002 05:12:23



The client has delivered an Oracle exp_name.dmp file to me and wishes
it to be converted into a SQL Server database.

Is there a * little utility that can help with this task?

I am under a time crunch, as always, so any help would be greatly
appreciated.

Thanks,
DaveO

 
 
 

Oracle .DMP file to SQL Server 2000

Post by Umachandar Jayachandra » Wed, 06 Mar 2002 06:58:20


    The binary format Oracle dump file needs Oracle & it's utilities. You
have to either install Oracle & import the data into it first and then
export it to SQL. Or get the data in ASCII format from Oracle so that you
can use it with BCP or BULK INSERT directly. You can also use DTS or Linked
Servers directly to import data.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )