Share via

Upgrade Analysis Services

Upgrading is performed by SQL Server Setup. SQL Server Setup can be used to upgrade any or all of its components, including Analysis Services.


To learn which Analysis Services features and functionality have been discontinued, deprecated, or changed see Analysis Services Backward Compatibility. For more information about upgrading an existing SQL Server instance, see Upgrade to SQL Server 2012.

Known Upgrade Issues

Before upgrading to SQL Server 2012 Analysis Services, review the release notes to confirm there are no late-breaking upgrade issues. 

Pre-Upgrade Checklist

Before upgrading, review the following information:

Upgrading Analysis Services

You can choose from several approaches to upgrade server and data:

  • An in-place upgrade replaces the existing program files with SQL Server 2012 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 SQL Server 2012 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.

In-place Upgrade

You can upgrade an existing instance of Analysis Services to SQL Server 2012 Analysis 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

Databases that were created in previous versions of Analysis Services run on the upgraded server under an older database compatibility level setting. Specifically, databases created in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 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).

See Also


Hardware and Software Requirements for Installing SQL Server 2012


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 Installation (SharePoint 2010)

Other Resources

Features Supported by the Editions of SQL Server 2012