RATE THIS ANSWER
+1
Click to Vote:
1
0
Last Answered:
May 14 2008 8:44 AM GMT
by Mrdenny
The migration tool and white papers on Microsoft.com are a good place to start. After creating your new tables and moving your data, you'll need to rewrite pretty much every stored procedure and function as Oracle and Microsoft SQL both use different languages.
After all this has been tested in Dev and QA you can deploy the tables and procedures to production and do the final data migration.
Testing will be the key to a successful migration.