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.
Oracle, SQL Server, Database, SQL Server 2005, Database migration
I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!! 
