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!!
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: 64111
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?

Regards
Michel

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


Current Time: Mon Dec 05 14:43:22 CST 2016

Total time taken to generate the page: 0.09534 seconds