Upgrade Assistant Tool for SQL Server 2012 (Ch.1.1 of 14): Upgrade Assistant Process
This article is part of the serie on the SQL Server Upgrade Assistant:
[[Upgrade Assistant Tool for SQL Server 2012]]1.0 Introduction
[[SQL Server Upgrade Assistant-Upgrade Assistant Process|1.1 Upgrade Assistant Process]]
[[SQL Server Upgrade Assistant-Upgrade Assistant Results|1.2 Upgrade Assistant Results]]
[[SQL Server Upgrade Assistant-Required Knowledge and Skills|1.3 Required Knowledge and Skills]]
[[SQL Server Upgrade Assistant-System Requirements|2.0 System Requirements]]
[[SQL Server Upgrade Assistant-Create a Test Environment|3.0 Create a Test Environment]]
[[SQL Server Upgrade Assistant-Create a Single Computer Test Environment|3.1 Single Computer Test Environment]]
[[SQL Server Upgrade Assistant-Create a Multiple Computer Test Environment|3.2 Multiple Computer Test Environment]]
[[SQL Server Upgrade Assistant-Installing SQL Server Upgrade Assistant|3.3 Install SQL Server Upgrade Assistant]]
[[SQL Server Upgrade Assistant-Capturing a Test Workload|4.0 Capture a Test Workload]]
[[SQL Server Upgrade Assistant-SQL Server 2005/2008 Baseline System|5.0 SQL Server 2005/2008 Baseline System]]
[[SQL Server Upgrade Assistant-Run Upgrade Advisor|6.0 Run Upgrade Advisor]]
[[SQL Server Upgrade Assistant-Replay Baseline Trace on SQL Server 2005/2008|7.0 Replay Baseline Trace on SQL Server 2005/2008]]
[[SQL Server Upgrade Assistant-Set Up Playback Test System|8.0 Set Up Playback Test System]]
[[SQL Server Upgrade Assistant-Replay Trace on SQL Server Code Name Denali|9.0 Replay Trace on SQL Server 2012]]
[[SQL Server Upgrade Assistant-Compare Trace Files|10.0 Compare Trace Files]]
[[SQL Server Upgrade Assistant-Advanced Topics|11.0 Advanced Topics]]
[[SQL Server Upgrade Assistant-Fixing Differences|12.0 Fixing Differences]]
[[SQL Server Upgrade Assistant-Troubleshooting|13.0 Troubleshooting]]
[[SQL Server Upgrade Assistant-Support|14.0 Support]]
This chapter contains:
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:
- Prepare test environment – set up test computers with necessary software and appropriate configuration. You should never conduct application compatibility testing using a production environment. Depending on the amount of load you want to subject your test systems to, you will also need one or mare computers to run the Distributed Replay software to replay the test load on the database servers.
- Capture test workload – backup relevant databases and capture a representative trace of your application’s workload that will be used in testing. This workload is usually captured from the produciton servers.
- Set up a 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) and develop fixes for any problems discovered.
- Replay test workload to establish baseline results – replay the captured trace workload on your test computers and capture relevant execution data and trace files
- Upgrade baseline environment – upgrade the baseline SQL Server instance to SQL Server 2012
- Replay test workload to establish upgrade results – replay the captured trace workload on your upgrade environment and capture relevant execution data and trace files
- 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 report 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: [[SQL Server Upgrade Assistant-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: [[SQL Server Upgrade Assistant-Upgrade Assistant Results]].
There are several steps which must be performed consistently for each database that is upgraded. To help track the upgrade process and ensure nothing falls through the cracks, we have developed a couple checklists which can be used to track the upgrade process and the resolution of any differences found by the Upgrade Assistant. Upgrade Assistant Checklists