Table of Contents for Upgrade Assistant:

1.0 Introduction
   1.1 Upgrade Assistant Process 
   1.2 Upgrade Assistant Results
   1.3 Required Knowledge and Skills
2.0 System Requirements
3.0 Create a Test Environment 
   3.1 Single Computer Test Environment 
   3.2 Multiple Computer Test Environment (this article)
   3.3 Install SQL Server Upgrade Assistant
4.0 Capture a Test Workload
5.0 SQL Server 2005/2008 Baseline System
6.0 Run Upgrade Advisor
7.0 Replay Baseline Trace on SQL Server 2005/2008
8.0 Set Up Playback Test System
9.0 Replay Trace on SQL Server 2012
10.0 Compare Trace Files
11.0 Advanced Topics
12.0 Fixing Differences
13.0 Troubleshooting 
14.0 Support  

 

3.2 Create a multiple-computer test environment

You can configure multiple computers to run SQL Server Upgrade Assistant (Upgrade Assistant). Choose this configuration to see trace files replayed simultaneously on both your pre- and post-upgrade configurations. To run the test on multiple computers, designate one computer for a baseline and another computer for the test. Configure both computers identically but give them different names. For example, name one computer BASELINE and the other computer TEST.

After you have configured the test computers to meet the above requirements, run Upgrade Assistant on the baseline computer. Follow the steps listed in the pane on the left side of Upgrade Assistant. The following table shows what steps to perform on each computer.

Table 3. Steps for using Upgrade Assistant

Step

Task                           

Computer

SQL Server Version

Notes

1

Create a Test Environment

Baseline

2005 / 2008

See the requirements in the previous section

2

Capture a Playback

Baseline

2005 /2008

See 4.0 Capturing a Workload Playback

3

Set Up Playback Baseline System

Baseline

2005 /2008

Restore your source database(s) to a SQL Server 2005/2008 instance including system databases (optional)

4

Run Upgrade Advisor

Baseline

2005 /2008

Identify issues that may prevent a successful upgrade

5

Replay Trace on SQL Server 2005/2008

Baseline

2005 /2008

Replay the trace workload you captured on your original SQL Server version (either 2005 or 2008)

6

Set Up Playback Test System

Test

2012

This is done on the TEST machine and can be started independent from the previous steps.

 

You will install a SQL Server 2012 instance on the test computer.

7

Upgrade to SQL Server 2012

Test

2012

You will restore a SQL Server 2012 instance on the TEST machine and restore the databases from your playback capture manually.

 

This is a side-by-side upgrade workflow.

8

Run TEST trace playback

Test

2012

Replay your trace workload on SQL Server 2012

9

Compare and analyze

Test

2012

Compare output from both replay tests and analyze the results using the report viewer

This table is just a high level summary.  Each step will be described in much more detail later in this document.  Once the test environment is created, you may proceed to [[SQL Server Upgrade Assistant-Installing SQL Server Upgrade Assistant|Installing SQL Server Upgrade Assistant]]