Skip to content

upgrade-process-overview.md

Latest commit

 

History

History
54 lines (38 loc) · 3.84 KB

upgrade-process-overview.md

File metadata and controls

54 lines (38 loc) · 3.84 KB
title Upgrade Process Overview | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
upgrading SQL Server
Upgrade Advisor [SQL Server], process description
SQL Server Upgrade Advisor, process description
upgrade process [Upgrade Advisor]
ms.assetid f77ffbab-a195-4124-acce-9c538f7ca9ce
author mashamsft
ms.author mathoma
manager craigg

Upgrade Process Overview

This topic provides best practice information for [!INCLUDEssCurrent] Upgrade Advisor and a summary of the recommended process for upgrading to [!INCLUDEssCurrent].

Upgrade Process

Servers that are running [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], or [!INCLUDEssSQL11] can be upgraded to [!INCLUDEssCurrent]. Whereas some [!INCLUDEssNoVersion] components can be upgraded in place, others must be migrated, and still others have been superseded by new components. For example, starting with [!INCLUDEssVersion2005], [!INCLUDEssISnoversion] ([!INCLUDEssIS]) supersedes Data Transformation Services (DTS), and DTS is no longer supported in [!INCLUDEssCurrent]. When you formulate your upgrade plan, you might need to plan for updating your current DTS packages to [!INCLUDEssIS] packages.

Upgrade Advisor enables you to evaluate current [!INCLUDEssNoVersion] installations, components, and related files to identify known issues that will cause problems both during and after you upgrade or migrate to [!INCLUDEssCurrent]. A few of these known issues block the [!INCLUDEssCurrent] upgrade. In the Upgrade Advisor report, these issues are identified as Upgrade Blockers. If you have not addressed the Upgrade Blockers before you run Setup, [!INCLUDEssCurrent] Setup exits and recommends that you run Upgrade Advisor to identify the specific issues that are blocking the upgrade.

As a best practice before upgrading to [!INCLUDEssCurrent], we recommend that you back up your data and system settings, and take strategic steps as outlined in the operational guidelines defined for your organization. Use the following steps to complete the upgrade:

  1. Review Hardware and Software Requirements for Installing SQL Server 2014.

  2. Back up data and system settings.

  3. Run Upgrade Advisor.

    Upgrade Advisor does not modify your data or change settings on your computer.

  4. Review the issues identified in the Upgrade Advisor report.

  5. Resolve any blocking issues that would prevent you from upgrading to [!INCLUDEssCurrent].

  6. Resolve any other pre-upgrade issues.

  7. Run Upgrade Advisor to verify that all known issues have been addressed.

  8. Run [!INCLUDEssCurrent] Setup.

  9. Resolve any post-upgrade and migration issues.

See Also

Running Upgrade Advisor (User Interface)
Using Reports
Working with Upgrade Advisor