Converting Oracle SQL syntax to MS SQL 2005 syntax looking for a tool

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iitt2007
    New Member
    • Feb 2008
    • 13

    #1

    Converting Oracle SQL syntax to MS SQL 2005 syntax looking for a tool

    I need to convert Oracle SQL SPs and functions to SQL 2005. Table and columns names do match. Is there any tool which will 'convert' Oracle script yntax to to SQL 2005 syntax?
    I can't install it on the server where DB is residing. I am looking for a standalone tool - pass input as Oracle Script and the tool spits out SQL 2005 syntax?
    Any one know if such a tool is available or I need to do manual work?
    Thanks.
  • Delerna
    Recognized Expert Top Contributor
    • Jan 2008
    • 1134

    #2
    I queried google and apparently there is no magic tool to convert
    try here

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      you need to do manual work .

      Comment

      Working...