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
Messages: 1
Registered: July 2007
Junior Member

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- 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.

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: 63912
Registered: March 2007
Location: Nanterre, France, http://...
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?


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

Current Time: Sun Oct 23 17:20:58 CDT 2016

Total time taken to generate the page: 0.07077 seconds