Home > IT Answers > Database > Migrate an Oracle database to SQL2005
mnman66
265 pts.
 Migrate an Oracle database to SQL2005
Database, Database migration, Oracle, SQL Server, SQL Server 2005
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!!

Software/Hardware used:
ASKED: March 22, 2008  12:37 PM
UPDATED: May 14, 2008  8:45 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  May 14, 2008  8:44 am  by  RequestFill CEO   160 pts.
All Answer Wiki Contributors:  RequestFill CEO   160 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.