locked
Oracle to SQL Migration RRS feed

  • Question

  • Hi,

    I want to know some migration tools for database and schema conversion from oracle to SQL Server

     

    Monday, January 16, 2012 4:13 PM

Answers

  • Charul,

    Have a look

    http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

    http://www.swissql.com/products/oracle-to-sqlserver/oracle-to-sql-server.html

     

     


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
    • Proposed as answer by Sandip Shinde Thursday, January 19, 2012 6:49 AM
    • Marked as answer by Stephanie Lv Monday, January 23, 2012 6:38 AM
    Monday, January 16, 2012 4:50 PM
  • Manish has pointed you to a couple of common tools that you should check out.

    A note:  Depending on the version of Oracle and the exact datatype used, some users have struggled to use the Microsoft migration tool to convert their database to SQL Server.   (Certainly these issues can be resolved.)

    Also, the code conversion is very helpful, but not always the best performing.  Depending on how the code was written (e.g. Oracle cursors seem to be more effective in some uses than Microsoft SQL Server equivalent cursors.)  you will probably want to review and manually modify some of the code.

    RLF


    • Edited by SQLWork Monday, January 16, 2012 6:22 PM
    • Proposed as answer by Sandip Shinde Thursday, January 19, 2012 6:49 AM
    • Marked as answer by Stephanie Lv Monday, January 23, 2012 6:38 AM
    Monday, January 16, 2012 6:21 PM

All replies