Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Import the .dmp file of Oracle into SQL Server2005

Author  Topic 

netrapalg
Starting Member

3 Posts

Posted - 2009-07-29 : 00:49:01
Hi All,
anybody suggest me that how can i import the .dmp file of oracle into SQL Server2005.i m trying to import the data through SQL Import and Export wizard.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-29 : 01:13:11
Hi

I think....
There is no direct way of importing a oracle .dmp file into sql server.
First you will need to import the .dmp file into your local Oracle server
then from there you can import the data into sql server using Import/Export wizard.

-------------------------
R..
Go to Top of Page
   

- Advertisement -