The SQL Server 2014 Upgrade Advisor

 

1.1 SQL Server Upgrade Readiness

One of the best ways to proceed with SQL Server upgrades is by running the Upgrade Advisor. The SQL Server 2014 Upgrade Advisor analyzes the configuration of installed SQL Server components, and then generates a report of issues that you must address to assure a successful upgrade.

1.1.1 To install the Upgrade Advisor

Either use the Upgrade Advisor installation file (sqlua.msi) in the redist folder of the installation media or download the *msi as part of the Microsoft SQL Server 2014 Feature Pack.

The best to way to get the items you need, use this download link:

Microsoft SQL Server 2014 Feature Pack

https://www.microsoft.com/en-us/download/details.aspx?id=42295

Select SQLDom.msi and SQLUA.msi (x64)

clip_image002

SQL Server 2014 Feature Pack Download

Install the downloaded files in the following order:

1. Install SQLDom.msi

2. Install SqlUA.msi

1.1.2 To Run the Upgrade Advisor

From the Start menu, lauch the SQL Server 2014 Upgrade Advisor.

clip_image004

SQL Server 2014 Upgrade Advisor – Home page

Start the Launch Upgrade Advisor Analysis Wizard. Click Next.

clip_image006

SQL Server 2014 Upgrade Advisor Analysis Wizard

Enter the SQL Server name, select components that you need to evaluate and click Next.

clip_image008

SQL 2014 Upgrade Advisor – Select Components

Select the Instance name, and appropriate Authentication method, click Next.

clip_image010

SQL 2014 Upgrade Advisor – Connection parameters

Select the appropriate databases to analyze, optionally select Analyze trace files and/or SQL batch files, click Next.

clip_image012

SQL 2014 Upgrade Advisor – Select Databases

Review Confirmation settings, then click Run.

clip_image014

SQL 2014 Upgrade Advisor – Confirm Selections

Upgrade wizard result dialog. The Launch Report button will display more detailed results.

clip_image016

SQL 2014 Upgrade Advisor –Results

1.1.3 View Upgrade Advisor Report

The Upgrade Advisor report can be run from the SQL Server 2014 Upgrade Advisor, shown at the begging of the last section, or from the completion dialog. Review and resolve any issues prior to the upgrade.

An example of a successful upgrade analysis report is shown next.

clip_image018

SQL 2014 Upgrade Advisor – Reporting

Advertisements
This entry was posted in SQL Server, SQL Server 2014. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s