Converting Oracle Scripts to SQL 2005 Scripts

• iitt2007

  SSC Veteran

  Points: 286

  More actions

  May 20, 2008 at 2:30 pm

  #190871

  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.

• DrMaltz

  SSC Enthusiast

  Points: 127

  More actions

  August 7, 2008 at 9:27 pm

  #854899

  Honestly, you should take a look at http://www.swissql.com/

  I used this to convert some routines into SQL 2000 sp(s), but it should also work for 2005 as well.

  I even think they offer a free online routine as well.. Check it out

  Good Luck!