Re: upgrade from 2000 to 2005
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Tue, 20 Dec 2005 17:12:46 -0500
You should try running this application. It might give you better reports.
http://www.microsoft.com/downloads/details.aspx?familyid=6107c27a-662c-4319-afe7-b52d1568c30a&displaylang=en
But in either case the upgrade will not FIX anything. If you have
incompatibilities you either have to run in 8.0 compatibility mode or fix
the issues. Please note that the Upgrade advisor tool listed above will
tell you if the issue needs to be addressed or is simply a warning. Not
using the WITH is a warning in most cases but not all.
--
Andrew J. Kelly SQL MVP
"BSuresh" <BSuresh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:25E3485B-B7B0-4BA7-A62C-F8B7552BB78B@xxxxxxxxxxxxxxxx
> As part of the preparation, I ran a sql script found in sqlservercentral
> that
> checks for unsupported rules such as table hint has to have the 'with' and
> other depricated rules. I got so many such errors as a result. will
> upgrade
> from 2000 to 2005 automatically fix these errors? Going throgh each
> objects
> to fix these manually is not applicable. I highly appreciate any of your's
> input.
>
> B
.
- Prev by Date: Re: best method for switching to a new server
- Next by Date: sql - dmz
- Previous by thread: best method for switching to a new server
- Next by thread: sql - dmz
- Index(es):
Relevant Pages
|
