升級 SQL Server 管理工具Upgrade SQL Server Management Tools

SQL Server 2014SQL Server 2014 支援從 SQL Server 2005SQL Server 2005 及更新版本升級。supports upgrade from SQL Server 2005SQL Server 2005 and later. 本主題說明升級 [SQL Server]SQL Server 管理工具和管理元件 (如 [SQL Server]SQL Server Agent、Database Mail、維護計畫、XPStar 和 XPWeb) 的支援與行為。This topic documents support and behavior for upgrading [SQL Server]SQL Server Management Tools and management components such as [SQL Server]SQL Server Agent, Database Mail, Maintenance Plans, XPStar, and XPWeb.

重要

若是本機安裝,您必須以管理員身分執行 [SQL Server]SQL Server 安裝程式。For local installations, you must run [SQL Server]SQL Server Setup as an administrator. 如果您是從遠端共用位置執行 [SQL Server]SQL Server 安裝程式,則必須使用對遠端共用位置具有讀取和執行權限的網域帳戶。If you run [SQL Server]SQL Server Setup from a remote share, you must use a domain account that has read and execute permissions on the remote share.

已知的升級問題Known Upgrade Issues

在您升級到 SQL Server 2014SQL Server 2014之前,請先考慮以下問題:Consider the following issues before you upgrade to SQL Server 2014SQL Server 2014:

如果是全部升級狀況:For all upgrade scenarios:

  • 在升級 MSX 伺服器之前,應該要升級所有的 TSX 伺服器。All TSX servers should be upgraded before the MSX server is upgraded. 如需 [SQL Server]SQL Server中 MSX/TSX 的詳細資訊,請參閱 將整個企業的管理自動化For more information about MSX/TSX in [SQL Server]SQL Server, see Automated Administration Across an Enterprise.

  • 您必須同時升級 [SQL Server]SQL Server 執行個體的所有元件。All components in an instance of [SQL Server]SQL Server must be upgraded at the same time. Database EngineDatabase Engine執行個體內, Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesSQL Server 2014SQL Server 2014元件的版本號碼都必須相同。Version numbers of the Database EngineDatabase Engine, Analysis ServicesAnalysis Services, and Reporting ServicesReporting Services components must be the same in an instance of SQL Server 2014SQL Server 2014.

  • 當您升級到 [SQL Server]SQL Server 時,可以將元件加入到現有的 SQL Server 2014SQL Server 2014安裝。You can add components to an existing installation of [SQL Server]SQL Server at the time that you upgrade to SQL Server 2014SQL Server 2014. 如需詳細資訊,請參閱 < 升級到使用的 SQL Server 2014 安裝精靈(安裝)For more information, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup).

  • [SQL Server]SQL Server 用戶端工具 (例如 SQL Server Management StudioSQL Server Management StudioSQL Server ProfilerSQL Server ProfilerDatabase EngineDatabase Engine Tuning Advisor、sqlcmd 和 osql) 不會升級到 SQL Server 2014SQL Server 2014Client Tools, such as SQL Server Management StudioSQL Server Management Studio, SQL Server ProfilerSQL Server Profiler, the Database EngineDatabase Engine Tuning Advisor, sqlcmd, and osql are not upgraded to SQL Server 2014SQL Server 2014. 用戶端工具改為使用舊版 [SQL Server]SQL Server 的工具進行並存執行。Instead, Client Tools run side-by-side with tools from previous [SQL Server]SQL Server versions. SQL Server 2014SQL Server 2014 支援從舊版的 [SQL Server]SQL Server 用戶端工具匯入設定。supports importing settings from earlier versions of [SQL Server]SQL Server Client Tools.

  • 在升級期間,從 [SQL Server]SQL Server Agent 到 [SQL Server]SQL Server 的驗證將會更新為 [SQL Server]SQL Server 驗證到 Windows 驗證。Authentication from [SQL Server]SQL Server Agent to [SQL Server]SQL Server will be updated from [SQL Server]SQL Server Authentication to Windows Authentication during upgrade. [SQL Server]SQL Server 中不支援 SQL Server 2014SQL Server 2014驗證。Authentication is not supported in SQL Server 2014SQL Server 2014.

  • 在升級到 SQL Server 2014SQL Server 2014的期間,將會保留作業與警示的資料。Data for jobs and alerts will be preserved during upgrade to SQL Server 2014SQL Server 2014.

  • 如果要升級的執行個體上有使用 SQLMail,關聯的 XP 將會在升級之後受到支援並啟用。If SQLMail is being used in the instance to be upgraded, associated XPs will be supported and enabled after the upgrade. 否則會將其關閉。Otherwise, they will be off.

  • Database Mail (也稱為 SQLiMail) 將會與 Database EngineDatabase EngineSQL Server 2014SQL Server 2014元件一起升級。Database Mail, also known as SQLiMail, will be upgraded with the Database EngineDatabase Engine component of SQL Server 2014SQL Server 2014. 根據預設,Database Mail 將會在升級之後關閉。By default, Database Mail will be off after upgrade. 任何結構描述更新都應該在升級之後與更新指令碼一致。Any schema updates should be reconciled with an update script after upgrade.

另請參閱See Also

支援的版本與版本升級 Supported Version and Edition Upgrades
回溯相容性 Backward Compatibility
升級為 SQL Server 2014 使用安裝精靈(安裝程式)Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)