使用 Upgrade Advisor 來準備升級Use Upgrade Advisor to Prepare for Upgrades

[SQL Server]SQL Server Upgrade Advisor 可以協助您完成升級到 SQL Server 2014SQL Server 2014 的相關準備工作。Upgrade Advisor helps you prepare for upgrades to SQL Server 2014SQL Server 2014. Upgrade Advisor 會分析已安裝的 [SQL Server]SQL Server 舊版元件,然後產生報告,以指出在您升級之前或之後要修正的問題。Upgrade Advisor analyzes installed components from earlier versions of [SQL Server]SQL Server, and then generates a report that identifies issues to fix either before or after you upgrade.

Upgrade Advisor 如何運作How Upgrade Advisor Works

當您執行 Upgrade Advisor 時,Upgrade Advisor 首頁會出現。When you run Upgrade Advisor, the Upgrade Advisor Home page appears. 您可以從首頁執行下列工具:From the Home page, you can run the following tools:

  • Upgrade Advisor 分析精靈Upgrade Advisor Analysis Wizard

  • Upgrade Advisor 報表檢視器Upgrade Advisor Report Viewer

  • Upgrade Advisor 說明Upgrade Advisor Help

第一次使用 Upgrade Advisor 時,請執行 Upgrade Advisor Analysis 精靈分析 [SQL Server]SQL Server 元件。The first time that you use Upgrade Advisor, run the Upgrade Advisor Analysis Wizard to analyze [SQL Server]SQL Server components. 當精靈完成分析時,請在 Upgrade Advisor 報表檢視器中檢視產生的報表。When the wizard finishes the analysis, view the resulting reports in the Upgrade Advisor Report Viewer. 每一份報告都會提供 Upgrade Advisor 說明資訊的連結,以協助您修正或降低已知問題的影響。Each report provides links to information in Upgrade Advisor Help that will help you fix or reduce the effect of the known issues.

Upgrade Advisor 分析Upgrade Advisor Analysis

Upgrade Advisor 會分析下列 [SQL Server]SQL Server 元件:Upgrade Advisor analyzes the following [SQL Server]SQL Server components:

  • Database EngineDatabase Engine

  • Analysis ServicesAnalysis Services

  • Reporting ServicesReporting Services

  • Integration ServicesIntegration Services

分析會檢查可以存取的物件,例如指令碼、預存程序、觸發程序和追蹤檔案。The analysis examines objects that can be accessed, such as scripts, stored procedures, triggers, and trace files. Upgrade Advisor 無法分析桌面應用程式或加密的預存程序。Upgrade Advisor cannot analyze desktop applications or encrypted stored procedures.

輸出為 XML 報表的形式。Output is in the form of an XML report. 請使用 Upgrade Advisor 報表檢視器來檢視 XML 報表。View the XML report by using the Upgrade Advisor report viewer.

注意

報表可能包含「其他升級問題」項目。Reports might contain an "other upgrade issues" item. 這個項目會連結到 Upgrade Advisor 不會偵測,但您的伺服器或應用程式中可能存在的問題清單。This item links to a list of issues that are not detected by Upgrade Advisor, but might exist on your server or in your applications. 您應該檢閱無法偵測到的問題清單,並判斷您是否因為這些無法偵測到的問題,而必須變更伺服器或應用程式。You should review the list of undetectable issues and determine whether you must change your server or applications because of the undetectable issues.

如何安裝和執行 Upgrade AdvisorHow to Install and Run Upgrade Advisor

安裝 [SQL Server]SQL Server Upgrade Advisor 的位置取決於您要分析的項目。The location where you install [SQL Server]SQL Server Upgrade Advisor depends on what you will be analyzing. Upgrade Advisor 支援所有支援元件 (Reporting ServicesReporting Services 除外) 的遠端分析。Upgrade Advisor supports remote analysis of all supported components except Reporting ServicesReporting Services. 如果不要掃描 Reporting ServicesReporting Services 的執行個體,可以將 Upgrade Advisor 安裝在可連接到 [SQL Server]SQL Server 的執行個體,且符合 Upgrade Advisor 必要條件的任何電腦上。If you are not scanning instances of Reporting ServicesReporting Services, you can install Upgrade Advisor on any computer that can connect to your instance of [SQL Server]SQL Server, and that meets the Upgrade Advisor prerequisites. 如需詳細資訊,請參閱 支援的版本與版本升級For more information, see Supported Version and Edition Upgrades. 如果您要掃描 Reporting ServicesReporting Services的執行個體,則必須將 Upgrade Advisor 安裝在報表伺服器上。If you are scanning instances of Reporting ServicesReporting Services, you must install Upgrade Advisor on the report server.

功能套件提供 Upgrade Advisor。Upgrade Advisor is available in a feature pack.

安裝及執行 Upgrade Advisor 的先決條件如下:Prerequisites for installing and running Upgrade Advisor are as follows:

  • Windows Server 2008Windows Server 2008 SP2、Windows 7 SP1 及 Windows Server 2008 R2Windows Server 2008 R2 SP1。SP2, Windows 7 SP1, and Windows Server 2008 R2Windows Server 2008 R2 SP1.

  • Windows Installer 從版本 4.5 開始。Windows Installer beginning with version 4.5. 您可以安裝 Windows Installer 從Windows Installer 網站You can install Windows Installer from the Windows Installer Web site.

  • Microsoft .NET Framework 4。Microsoft .NET Framework 4. .NET framework 4 是位於SQL Server 2014SQL Server 2014產品媒體,以及從.NET Framework 4 下載頁面.NET Framework 4 is available on the SQL Server 2014SQL Server 2014 product media, and from the .NET Framework 4 download page.

    • 若要從 SQL Server 2014SQL Server 2014 媒體安裝 .NET Framework 4,請找出光碟機的根目錄。To install the .NET Framework 4 from the SQL Server 2014SQL Server 2014 media, locate the root of the disk drive. 然後,在 \redist 資料夾上按兩下滑鼠按鈕後於 DotNetFrameworks 資料夾上再按兩下滑鼠按鈕,然後執行 dotNetFx40_Full_x86_x64.exe (32 位元作業系統或 64 位元作業系統)。Then, double-click the \redist folder, double-click the DotNetFrameworks folder, and run dotNetFx40_Full_x86_x64.exe (for 32-bit operating systems or for 64-bit operating systems).

若要從網路安裝 Upgrade Advisor,請在下載網頁上按一下 [下載] 按鈕。To install Upgrade Advisor from the Web, click the download button on the download page. 接著您可立即執行安裝,或是儲存 SQLUA.msi 檔,並於稍後再執行。You can then run installation immediately, or save the SQLUA.msi file to run later. 如果要從產品光碟安裝,請直接從產品光碟執行 SQLUA.msi。If you are installing from the product disc, run SQLUA.msi directly from the product disk.

安裝 Upgrade Advisor 之後,您可以開啟從啟動功能表:After you install Upgrade Advisor, you can open it from the Start menu:

  • 按一下 開始,指向所有程式,指向Microsoft SQL Server 2014Microsoft SQL Server 2014,然後按一下 SQL Server 2014SQL Server 2014 Upgrade AdvisorClick Start, point to All Programs, point to Microsoft SQL Server 2014Microsoft SQL Server 2014, and then click SQL Server 2014SQL Server 2014 Upgrade Advisor.

如需詳細資訊,請參閱 Upgrade Advisor 下載以及 SQL Server 2014SQL Server 2014 版本資訊中的 Upgrade Advisor 文件。For more information, see the Upgrade Advisor documentation included in the Upgrade Advisor download and the SQL Server 2014SQL Server 2014 Release Notes.

另請參閱See Also

使用多個版本和 SQL Server 執行個體 Work with Multiple Versions and Instances of SQL Server
支援的版本與版本升級 Supported Version and Edition Upgrades
回溯相容性Backward Compatibility