Resources For IT Professionals
Page Details
  • First published by (dMicrosoft Partne)
  • When: 21 Mar 2011 1:03 PM
  • Last revision by (MVP, Microsoft Community Contributor)
  • When: 22 Sep 2013 3:31 AM
  • Revisions: 6
  • Comments: 0
Options

Revision #2

Wiki  >  TechNet Articles  >  1.1 Upgrade Assistant Process  >  Revision #2
1.1 Upgrade Assistant Process
You are currently reviewing an older revision of this page.
Go to current version

1.1 Overview of Application Compatibility Testing Process

Application compatibility testing using Upgrade Assistant is simple provided you prepare your test environment correctly in advance. The following summarizes the key steps involved:

 

  1. Prepare test environment – set up test computers with necessary software and appropriate configuration.  You should never conduct application compatibility testing using a production environment.
  2. Capture test workload – backup relevant databases and capture a representative trace of your application’s workload that will be used in testing. 
  3. Set up baseline environment – transfer the relevant files and databases to your baseline test environment –  run Upgrade Advisor – review Upgrade Advisor results (analyze database schema, trace files and script files for potential compatibility issues)
  4. Replay test workload to establish baseline results – replay the captured trace workload on your test computers and capture relevant execution data and trace files
  5. Upgrade baseline environment – upgrade the baseline SQL Server instance to SQL Server Code Name “Denali”
  6. Replay test workload to establish upgrade results – replay the captured trace workload on your upgrade environment and capture relevant execution data and trace files
  7. Compare results – compare and review data from the baseline and upgrade test workload replays to identify potential compatibility issues.  The differences are presented to you in a grid that allows you to navigate through the differences detected, filter out irrelevant differences, and analyze differences to determine if they will require changes to your applications to compensate.

 This process requires some minimal SQL Server skills to execute.  The required skills are listed here:  1.3 Required Knowledge and Skills

Upgrade Assistant automates most of the tasks in each step of your testing. If you follow the instructions provided, your testing should be smooth and productive.  The next step in the process is to review the results produced by the upgrade assistant; 1.2 Upgrade Assistant Results