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.

Important note Important

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.

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

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.

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.

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).