36
Migrating to a Dell PowerEdge R515 server from two legacy database servers
APPENDIX F – INSTALLING UPGRADE ADVISOR
In this appendix, we walk through the steps to install and run the SQL
Server 2008 R2 Upgrade Advisor and save Upgrade Advisor reports.
1. Insert the SQL Server 2008 R2 DVD to the machine in which you
wish to install the Upgrade Advisor. On the Planning screen, click
Install SQL Server Upgrade Advisor.
2. Click Next to begin the installation wizard, accept the licensing
terms, and click Next.
3. Click Next to accept the default Registration information, click
Next to accept the default installation path, and click Next to
begin the installation.
4. At the Completing the Microsoft SQL Server 2008 R2 Upgrade
Advisor screen, click Finish to exit the setup.
5. Start the Upgrade Advisor by selecting StartAll
ProgramsMicrosoft SQL Server 2008 R2SQL Server 2008 R2
Upgrade Advisor.
6. Click the Launch Upgrade Advisor Analysis Wizard link.
7. At the Welcome screen, click Next.
8. On the SQL Server Components screen, by default the Upgrade
Advisor populates the server name field with the local computer
name. If you need to scan a remote server, type the computer
name or IP address of the SQL Server you want to analyze and do
one of the following:
a. Click Detect to allow the Upgrade Advisor to scan the
components on the SQL Server instance you specified. (We
chose this option.)
b. Select the components of the SQL Server instance you
would like the Upgrade Advisor to scan.
9. On the Connection Parameters screen, specify the Authentication
Type and credentials if necessary.
10. On the SQL Server parameters screen, select one or more
databases and, if you so desire, supply a trace file or SQL script file
to analyze. Should you wish to use a trace file, you must generate
it before you begin the Upgrade Advisor. For instructions about
how to generate a trace file, see http://msdn2.microsoft.com/en-
us/library/ms187929(SQL.105).aspx.
11. If you specified analysis of Data Transformation Packages (or if the
detection process discovered DTS on the SQL Server 2000 server),
you should now choose whether you want the Upgrade Advisor to
scan for (a) DTS packages on the SQL Server 2000 server or (b)
DTS package files stored on the file system. Click Next to continue.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales