There is an entire whitepaper by Microsoft on Migrating from ORACLE
Download the whitepaper and you should be in a much better position to do
MCP SQL Server
>I am using Oracle. I would like to migrate to SQL 6.5/7.0
>How would I do it? Is there any utility by which I can do the tranfer?
>I tried using Tools --> Object Transfer --> Foreign Source. But giving
>the Oracle IP does not work.
>Anybody who has done it before..?
>Thanks in advance
>Johns T. Joseph