This article is part of the serie on the SQL Server Upgrade Assistant:

Upgrade Assistant Tool for SQL Server 2012 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 

   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  

 

This chapter contains:

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]]