Import Oracle *.DMP into MS-SQL (without Oracle DB Server)

[johncogan]

Hi I am having no luck in finding some way (or tool) that will allow me to import an Oracle DMP file into SQL DB or convert the file into some form that will allow me to recreate the Oracle DB on the SQL DB (Only the schema is needed, so not working with data) Any help in this regard is greatly appreciated. Ta John

[RichardGrimmer]

Best method to get the schema (and the data for that matter) would be to use a DTS task....Simply set Oracle as the source, SQL as the destination, and elect to import ALL objects.... "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox

[Steve S]

Except that DTS will talk to ORACLE, not a DMP file, so if you don't have ORACLE client installed, this won't work. Rich's suggestion is a good one, though.* Steve S *I can't believe I just wrote that