Oracle to SQL Server migration

Question

Hi - We need to migrate Oracle database  to SQL Server.   We need all tables, stored procedures,views,indexes etc. along with the data to be migrated to sql server.

I learnt the SSMA for oracle tool will do this task. 

- Is SSMA for Oracle is reliable

- What are the steps to follow for migration. Please share if you have any checklist

- What is the best approach for migration

- Is there any other tools available

 Please share your personal experience on this excercise and best practices to be followed.

thanks  

Answer 1

Hi RR Netha,

SQL Server Migration Assistant for Oracle is reliable. Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle databases to Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server “Denali”. SSMA for Oracle converts Oracle database objects to SQL Server database objects, creates those objects in SQL Server, and then migrates data from Oracle to SQL Server.

Download Microsoft Migration Assistant for Oracle: http://www.microsoft.com/download/en/details.aspx?id=28766.

Below documentation introduces you to SSMA for Oracle and provides step-by-step instructions for migrating Oracle databases to SQL Server. SQL Server Migration Assistant for Oracle:  http://msdn.microsoft.com/en-us/library/hh313179.aspx.

Also refer to http://blogs.msdn.com/b/ssma/archive/2010/08/27/migrating-oracle-s-sample-hr-schema.aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

I have done Oracle 10g to SQL server 2008R2 migration using SSMA tool. Yes this tool is very user friendly and easy to operate. You can refer following links for reference. 

•  http://technet.microsoft.com/en-us/library/hh313159.aspx
• http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle
• http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24662

Reliability depends on the complexity of the objects in your database, in my case there were few databases where everything was migrated by SSMA but for for few databases there were many objects which required manual efforts to update the PL/SQL code. It took 10 days to fix all code.

So be ready to convert code manualy for objects where you see errors in SSMA.