April 1, 2009 at 9:30 am
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 1, 2009 at 1:12 pm
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
any suggestions
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply