Oracle to SQL Server migration RRS feed

  • 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.


    Monday, February 20, 2012 4:18 PM


  • 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.


    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.

    • Marked as answer by Maggie Luo Wednesday, February 29, 2012 1:51 AM
    Wednesday, February 22, 2012 2:57 AM

All replies