升級 Analysis ServicesUpgrade Analysis Services

使用 [SQL Server]SQL Server 安裝程式來升級 [SQL Server]SQL ServerUse [SQL Server]SQL Server Setup to upgrade [SQL Server]SQL Server. 如需有關以 SharePoint [SQL Server]SQL Server模式升級的詳細資訊, 請參閱升級 PowerPivot for SharePointFor detailed information on upgrading [SQL Server]SQL Server in SharePoint mode, see Upgrade PowerPivot for SharePoint. 如需升級現有 SQL Server 實例的詳細資訊, 請參閱使用安裝精靈(安裝程式)升級至 SQL Server 2014For more information about upgrading an existing SQL Server instance, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup).

已知的升級問題Known Upgrade Issues

在升級至 SQL Server 2014SQL Server 2014 Analysis ServicesAnalysis Services之前,請檢閱下列文章:Before upgrading to SQL Server 2014SQL Server 2014 Analysis ServicesAnalysis Services, review the following:

升級前檢查清單Pre-Upgrade Checklist

升級之前,請先檢閱下列資訊:Before upgrading, review the following information:

升級 Analysis ServicesUpgrading Analysis Services

您可以選擇許多方式來升級伺服器和資料:You can choose from several approaches to upgrade server and data:

  • 就地升級會以SQL Server 2014SQL Server 2014程式檔案取代現有的程式檔案。An in-place upgrade replaces the existing program files with SQL Server 2014SQL Server 2014 program files. 資料庫會保持在相同的位置。Databases remain in the same location. 程式資料夾會更新以反映新的名稱。Program folders are updated to reflect the new name.

  • 並存升級是指SQL Server 2014SQL Server 2014在具有現有 Analysis Services 實例的同一部電腦上的新安裝。A side-by-side upgrade is a new installation of SQL Server 2014SQL Server 2014 on the same computer that has an existing Analysis Services instance. 您可以將資料庫移至相同電腦上的新執行個體,然後解除安裝舊版 (如果不再使用它的話)。You can move databases over to the new instance on the same computer, and then uninstall the old version if you no longer use it.

  • 您也可以在新的硬體上安裝 Analysis Services,然後將現有的資料庫移轉至該伺服器。You can also install Analysis Services on new hardware and then migrate existing databases to that server.

就地升級In-place Upgrade

您可以將 Analysis ServicesAnalysis Services 的現有執行個體升級到 SQL Server 2014SQL Server 2014 Analysis ServicesAnalysis Services and, as part of the upgrade process, au的現有執行個體升級到matically migrate existing databases from the old instance 的現有執行個體升級到 the new instance.You can upgrade an existing instance of Analysis ServicesAnalysis Services to SQL Server 2014SQL Server 2014 Analysis ServicesAnalysis Services and, as part of the upgrade process, automatically migrate existing databases from the old instance to the new instance. 由於這兩個版本之間的中繼資料和二進位資料是相容的,所以在您升級之後將會保留資料,而且不必手動移轉資料。Because the metadata and binary data is compatible between the two versions, you will retain the data after you upgrade and you do not have to manually migrate the data.

若要升級現有的執行個體,請執行安裝程式,並指定現有執行個體的名稱做為新執行個體的名稱。To upgrade an existing instance, run Setup and specify the name of the existing instance as the name of the new instance.

升級資料庫Upgrading Databases

在舊版 Analysis ServicesAnalysis Services 中建立的資料庫會使用舊的資料庫相容性層級設定,在升級的伺服器上執行。Databases that were created in previous versions of Analysis ServicesAnalysis Services run on the upgraded server under an older database compatibility level setting. 在下列版本中建立的資料庫,其資料庫相容性層級為 105。Databases created in the following versions, have a database compatibility level of 105. 如果您想要使用的功能需要更新的資料庫相容性層級,就可以變更相容性層級。You can change the compatibility level if you want to use features that require a newer database compatibility level. 否則,您可以使用原始設定,在升級的伺服器上執行資料庫。Otherwise, you can run the databases on the upgraded server using the original settings. 如需詳細資訊, 請參閱設定多維度資料庫(的相容性)層級 Analysis ServicesFor more information, see Set the Compatibility Level of a Multidimensional Database (Analysis Services).

  • SQL Server 2012SQL Server 2012

  • SQL Server 2008SQL Server 2008

  • SQL Server 2008 R2SQL Server 2008 R2

  • SQL Server 2005SQL Server 2005

另請參閱See Also

SQL Server 2014 版本所支援的功能 Features Supported by the Editions of SQL Server 2014
規劃 SQL Server 安裝 Planning a SQL Server Installation
瞭解 Microsoft OLAP 架構 Understanding Microsoft OLAP Architecture
升級 PowerPivot for SharePoint Upgrade PowerPivot for SharePoint
以多維度及資料採礦模式安裝 Analysis Services Install Analysis Services in Multidimensional and Data Mining Mode
PowerPivot for SharePoint 2010 安裝PowerPivot for SharePoint 2010 Installation