Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2008
    Posts
    4

    Unanswered: Automatic joins syntax replacement tool ?

    Hello,

    I have about 900 stored procedures where the developers used the 'old' inner and outer join syntax '*=' and '=*'.
    Is there a tool which can automatically transform the source using the ANSI syntax ?

    Thank you for your help.

  2. #2
    Join Date
    Nov 2008
    Posts
    4

    Desperate sql developer

    Really no tools for such a huge change ?

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well, you'd need to know which parts of the WHERE clause to use as the ON clause... computers aren't clever; it'd take some pretty heavy user-intervention.
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2008
    Posts
    4

    Sure !

    >> computers aren't clever
    Sure !

    Hope is life.
    May be I'll stop living.

  5. #5
    Join Date
    Nov 2008
    Posts
    4

    Smile May be a solution !

    May be I'll live a bit more.

    Computers are not clever enough, sure, but maybe men are clever enough to let computers do the job.

    The solution may be here :
    http://www.swissql.com/products/sql-...converter.html

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    how much is the license fee? they cleverly do not mention it on their site

    and you'll need a license, because the evaluation version only converts 50 queries and you have 900
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by r937
    how much is the license fee? they cleverly do not mention it on their site
    In fact they do if you click on the "Buy now" button

    https://store.adventnet.com/jsp/fp.j...10006&p1=10053

    The single license is 290

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •