Post reply

upgrade to sql 2005

  • April 1, 2009 at 9:30 am

    #201682

    currently we are trying to upgrade our servers to sql server 2005 and my main job is as a sql developer to review all the procedures function, views, triggers, .... whether they are 2005 compliant.

    And I have now like more than 500+ database objects to review, and going one by one is kinda cumbersome; So my question is Is there any other brilliant way to find all the database objects which nees to be reviewed and changed insead of going one by one in the database?

    Thanks,

  • April 1, 2009 at 9:34 am

    #970000

    The upgrade advisor should help here.

    You ought to look at 2008 instead. Same license cost, longer support, about the same compatibility as 2005 with 2000.

  • April 1, 2009 at 1:12 pm

    #970175

    Thank you for your response, I have tryed to user sql upgrade advisor, I am encoutering a problem

    "SQL BPA command line has encountered a problem and needs to close"

    and couldn't get the solution I useed this suggestion still didn't work

    http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff/

    any suggestions

    Thanks,

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

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