Migrating Oracale database into Sql Server2005

  • Hi All,

    I want to migrate Oracle Database structure,data,stored procedures,triggers and rest of the relevant database objects in Sql Server 2005.How to accomplish that?

    Is there any third party tool to do that or there is facilities available  in Sql Server 2005 through which we can convert Sql Server 2005 and all the objects of it.

     

    Thanks

    Madhusudan.

     

  • I have used a program called SQLWays.  It works pretty well but there will be things that will require manual recoding. 

    To read about the migration process and to familiarize yourself with the SQLWays User Guide, please consult the Product Documentation included into the installation package and available on the Ispirer Systems website at http://www.ispirer.com/doc .

    For more information about SQLWays: its key benefits, history and new releases, as well as about its developers and the services that they render, please visits the website of Ispirer Systems at http://www.ispirer.com .

    Good Luck

  • Microsoft offers a migration tool also.

    http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply