Installing Upgrade Advisor from the Command Prompt
You can install Upgrade Advisor either by using the Setup Wizard or from the command prompt. By using the command prompt you can perform unattended and automated installations.
Installation Syntax
The basic syntax for installing Upgrade Advisor from the command prompt is as follows:
SQLUA.msi [options]
The following table shows the most common options.
| Argument | Description |
|---|---|
| /q[n|b|r|f] | Sets user interface (UI) level: n = no UI b = basic UI (progress only, no prompts) r = reduced UI (dialog box at the end of installation) f = full UI |
| /L | Specifies log file options. To log all messages to log_file_name, use -L*vlog_file_name. To log error messages only, use -Lelog_file_name. |
| ADDLOCAL=ALL| REMOVE=ALL|REINSTALL=ALL | Specifies to install (ADDLOCAL), remove (REMOVE), or reinstall (REINSTALL) Upgrade Advisor. |
| UAINSTALLDIR=path | Installs Upgrade Advisor to the location specified by path. |
Installation Examples
The following example shows how to install Upgrade Advisor by using the command prompt:
SQLUA.msi /qn ADDLOCAL=ALL UAINSTALLDIR="C:\Upgrade Advisor"
You can also use the Msiexec program when you run this command:
Msiexec.exe /i C:\Downloads\SQLUA.msi /qn ADDLOCAL=ALL UAINSTALLDIR="C:\Upgrade Advisor"
This can be helpful if you have to use additional installation options.
Removal Examples
The following example shows how to remove Upgrade Advisor by using the command prompt:
SQLUA.msi /qn REMOVE=ALL
You can also use the Msiexec program when you run this command:
Msiexec.exe /i C:\Downloads\SQLUA.msi /qn REMOVE=ALL