How to use Upgrade Advisor

Using Upgrade Advisor

This section will provide you a brief about How to upgrade advisor

1.) Go to Start –> All Programs –> Microsoft SQL Server 2005 –> SQL Server 2005 Upgrade Advisor, open upgrade advisor

install_upgrade_advisor_1

2.) Click on the Launch upgrade advisor analysis wizard to begin work with upgrade advisor.

install_upgrade_advisor_2

3.) Click on next, you will see the below screen where you can select the services which should be analyzed by upgrade advisor.

install_upgrade_advisor_3

4.) After selecting the services click next, you will get the below screen where you need to provide necessary credentials to connect sql2000 for analysis.

install_upgrade_advisor_4

5.) In the below screen select the databases which you need to analyze.

install_upgrade_advisor_5

6.) In the below screen you can specify whether to analyze DTS on sql2000 or not. You can even specify a legacy DTS package for analysis by selecting the option Analyze DTS package files

install_upgrade_advisor_6

7.) By providing all the information, it will provide a summary for which its going to analyze. Click on run to start analyzing Sql2000.

install_upgrade_advisor_7

8.) On completion of analysis the wizard will provide you the next screen as below, you can click on the launch report button to view the entire scanned report.

install_upgrade_advisor_8

9.) You will be provided with the report as below, where you can see all the components which are not compatible with sql2005, hence you can plan accordingly.

install_upgrade_advisor_9

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *

*


x

Related Posts

CSSUG October 2019 Meet
We are proud to share CSSUG is getting resumed after couple of years. All the hard work and initiation is done by Madhivanan. Thanks to Madhi fo...
Dropping a Subscriber from AG Publisher
Today one of my colleague reached out to me for an help to drop a subscriber from an publisher which is participating in Always On. We seen same...
Batch Script to Deploy Multiple SQL files (Version 2)
I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch fi...
powered by RelatedPosts