Working with Upgrade Advisor

SQL Server 2014

To help ensure that your upgrade to SQL Server 2014 is successful, Upgrade Advisor provides a central console to identify issues to address in your installations before upgrading to SQL Server 2014.

You can use Upgrade Advisor to perform the following tasks:

  • Analyze previous version's components on local or remote servers.

    System_CAPS_ICON_important.jpg Important

    You cannot analyze remote instances of Reporting Services.

  • View the results of the analysis.

Upgrade Advisor includes an analyzer and a viewer. The Upgrade Advisor Analysis Wizard analyzes the components you select. The analyzer then generates custom reports about issues that you must handle before you can upgrade to SQL Server 2014. You use the Upgrade Advisor Report Viewer to view the custom reports. For more information about what Upgrade Advisor analysis detects, see Resolving Upgrade Issues.

The topics in this section provide an overview of Upgrade Advisor functionality and information about how to use Upgrade Advisor and Upgrade Advisor reports.

Overview of Upgrade AdvisorProvides an overview of the upgrade process, the Upgrade Advisor Analysis Wizard, and the Upgrade Advisor Report Viewer.
Upgrade Advisor How-to TopicsProvides instructions to perform common Upgrade Advisor procedures.
Upgrade Advisor User Interface ReferenceContains topics that appear if you press the F1 key or click Help on the Upgrade Advisor Analysis Wizard pages.

Installing Upgrade Advisor
Resolving Upgrade Issues