Install Upgrade advisor 2014 – Before database upgrade

Database upgrade – Install Upgrade Advisor

SQL Server upgrade Advisor tool helps you to analyze sql server component installed in your environment before upgrading to next version of SQL Server also generates the report that helps you to identify the issues in existing environment that can be fix either before or after upgrade.

Prerequisites for installing Upgrade Advisor

  1. Operating System should be Windows Server 2008 SP2, Windows 7 SP1 and Windows Server 2008 R2 SP1 or later.
  2. Window Installer 4.5 should be installed, Download from Microsoft Window website
  3. Microsoft .NET Framework 4, .NET Framework 4 download page.
  4. Before Installing Upgrade Advisor, you need to install SQL Server 2014 Transact- SQL Dom (SqlDom.msi)
  5. Upgrade Advisor is part of SQL Server 2014 media setup, if you want to install it separately than go to SQL Server 2014 Feature Pack and download both Upgrade Advisor (SqlUA.msi) and Transact-SQL Dom(SqlDom.msi) from Microsoft Download center

These prerequisites are also available in SQL Server 2014 Setup media under \x64\redist\ folder

How to Install SQL Server Upgrade Advisor 2014

Once you downloaded all files, install it all prerequisites than double click on SqlUA.msi to start install

SQL server upgrade advisor 2014

If you missed to run SqlDom.msi before installation of SQL Server Upgrade Advisor than you will get below error that clearly says setup is missing prerequisites.

sqlserver2014 missing prerequisites

Once you installed Sqldom.msi successfully again double click on SqlUA.msi to start installation of Upgrade Advisor

sql server upgrade setup file

Click next to proceed

sql server upgrade license agreement

Go through the terms in the license agreement and click on I accept and click on next to proceed

sql server advisor feature install

Select -> Entire feature will be installed on local drive

Disk cost for upgrade advisor

Click on Disk cost button to check the space requirement (optional – You should have sufficient space)

Click next to proceed

Ready to install upgrade advisor 2014

Click on Install

installing and copying file for upgrade advisor 2014

sql server upgrade 2014 is completed

Click on Finish to exit

Leave a Reply

  

  

  


+ 8 = 10