Post reply

App to migrate or report SQL Sentences that need to be changed

  • September 7, 2012 at 9:46 am

    #261292

    We're migranting from SQL 2000 to SQL 2008 r2. Since there are huge amount of stored procedures involved that need to be tested, does any body know of any app that can scan (read) all stored procedures an report any SQL sentence that need to be changed.

    Thanks...

  • September 7, 2012 at 9:52 am

    #1535147

    Hi

    we use Red Gate Tools - one of which is SQL Script which could script your DB and you could do a check on that.

    However, I think that 2008 (with SP1) vs. 2008R2 would be minor, as 2008R2 is the minor upgrade from 2008 SP1.

    Clearly MS added new features, but I wasn't aware of any syntax/key word changes between 2008SP1 and 2008 R2

    This may be of use

    http://msdn.microsoft.com/en-us/library/bb500435%28SQL.105%29.aspx

  • September 7, 2012 at 10:26 am

    #1535164

    TanglyPegasus,

    Thanks for your help.

    We're migrating from SQL 2000, not 2008 SP1. We are aware that there are some sintax / key word difference that need to be address. Since we have so many stored procedures we are looking for something that can automate this search so we can go directly to solve the issues detected.

  • September 7, 2012 at 10:46 am

    #1535177

    Have you run the Upgrade Advisor? It might do what you need.

    http://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx

    I'm not sure if some of the RedGate tools would help.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 4 (of 4 total)

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