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.
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
Select SQLDom.msi and SQLUA.msi (x64)
SQL Server 2014 Feature Pack Download
Install the downloaded files in the following order:
1. Install SQLDom.msi
2. Install SqlUA.msi
From the Start menu, lauch the SQL Server 2014 Upgrade Advisor.
SQL Server 2014 Upgrade Advisor – Home page
Start the Launch Upgrade Advisor Analysis Wizard. Click Next.
SQL Server 2014 Upgrade Advisor Analysis Wizard
Enter the SQL Server name, select components that you need to evaluate and click Next.
SQL 2014 Upgrade Advisor – Select Components
Select the Instance name, and appropriate Authentication method, click Next.
SQL 2014 Upgrade Advisor – Connection parameters
Select the appropriate databases to analyze, optionally select Analyze trace files and/or SQL batch files, click Next.
SQL 2014 Upgrade Advisor – Select Databases
Review Confirmation settings, then click Run.
SQL 2014 Upgrade Advisor – Confirm Selections
Upgrade wizard result dialog. The Launch Report button will display more detailed results.
SQL 2014 Upgrade Advisor –Results
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.
SQL 2014 Upgrade Advisor – Reporting