| Import Oracle dmp file into SqlServer [message #251225] |
Thu, 12 July 2007 13:14  |
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  |
 |
Michel Cadot
Messages: 68718
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
