Home » RDBMS Server » Backup & Recovery » Import Oracle dmp file into SqlServer
- Import Oracle dmp file into SqlServer [message #251225] Thu, 12 July 2007 13:14 Go to next message
joepinto123
Messages: 1
Registered: July 2007
Junior Member
Hello,

I know this might be an odd one for this forum but this place has helped me find answers before.
I have worked on Oracle quite a bit but completely new to SQLServer. I have a few dump files- 9.2.0.7 and 10g ones created using "EXP" (not expdp). I'm struggling to find a way to import them into SQLServer.

I only care about the data (and schema of course). I don't care about the procedures, triggers etc.

Thanks!!

Report message to a moderator

- Re: Import Oracle dmp file into SqlServer [message #251232 is a reply to message #251225] Thu, 12 July 2007 13:20 Go to previous message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
export dump file is Oracle proprietary format, I don't think you can directly use it to import into SQLServer (actually it is possible but painful).
Why not spooling the data in a CSV format and import it in SQLServer? I think it can read this can of format, doesn't it?

Regards
Michel

Report message to a moderator

Previous Topic: Backup Method
Next Topic: I will like to backup one database and restore to another
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 04 08:40:58 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.