Oracle to SQL SERVER

Oracle 9i to SQL 2K
Can someone shed some light , how can I create SQL server db objects from
the dmp file (export from Oracle).
I need to create the schema and later load data in SQL SERVER..
Any links or related topics will be highly appreciated.
Thanks
ShThis should help:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part2/c0761.asp
I don't believe you can go directly from the dmp file to a sql schema but
you should be able to use DTS to get you going. The doc will point you in
the right direction though.
--
Andrew J. Kelly
SQL Server MVP
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:una9y6abDHA.2476@.tk2msftngp13.phx.gbl...
> Oracle 9i to SQL 2K
> Can someone shed some light , how can I create SQL server db objects from
> the dmp file (export from Oracle).
> I need to create the schema and later load data in SQL SERVER..
> Any links or related topics will be highly appreciated.
> Thanks
> Sh
>
>