| title | Upgrade Analysis Services | Microsoft Docs | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||
| ms.date | 05/24/2017 | |||||||||
| ms.prod | sql-server-2014 | |||||||||
| ms.reviewer | ||||||||||
| ms.technology | ||||||||||
| ms.topic | conceptual | |||||||||
| helpviewer_keywords |
|
|||||||||
| ms.assetid | a131d329-386e-4470-aaa9-ffcde4e5ec0c | |||||||||
| author | Minewiskan | |||||||||
| ms.author | owend | |||||||||
| manager | craigg |
Use [!INCLUDEssNoVersion] Setup to upgrade [!INCLUDEssNoVersion]. For detailed information on upgrading [!INCLUDEssNoVersion] in SharePoint mode, see Upgrade PowerPivot for SharePoint. For more information about upgrading an existing SQL Server instance, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup).
Before upgrading to [!INCLUDEssCurrent] [!INCLUDEssASnoversion], review the following:
-
To learn which [!INCLUDEssASnoversion] features and functionality have been discontinued, deprecated, or changed see Analysis Services Backward Compatibility.
Before upgrading, review the following information:
You can choose from several approaches to upgrade server and data:
-
An in-place upgrade replaces the existing program files with [!INCLUDEssCurrent] program files. Databases remain in the same location. Program folders are updated to reflect the new name.
-
A side-by-side upgrade is a new installation of [!INCLUDEssCurrent] 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.
-
You can also install Analysis Services on new hardware and then migrate existing databases to that server.
You can upgrade an existing instance of [!INCLUDEssASnoversion] to [!INCLUDEssCurrent] [!INCLUDEssASnoversion] 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.
Databases that were created in previous versions of [!INCLUDEssASnoversion] run on the upgraded server under an older database compatibility level setting. 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. For more information, see Set the Compatibility Level of a Multidimensional Database (Analysis Services).
-
[!INCLUDEssSQL11]
-
[!INCLUDEssKatmai]
-
[!INCLUDEssKilimanjaro]
-
[!INCLUDEssVersion2005]
Features Supported by the Editions of SQL Server 2014
Planning a SQL Server Installation
Understanding Microsoft OLAP Architecture
Upgrade PowerPivot for SharePoint
Install Analysis Services in Multidimensional and Data Mining Mode
PowerPivot for SharePoint 2010 Installation