Export (0) Print
Expand All

Upgrade Analysis Services

Use SQL Server Setup to upgrade SQL Server. For detailed information on upgrading SQL Server 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 SQL Server 2014 Analysis Services, review the following:

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

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

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

  • SQL Server 2012

  • SQL Server 2008

  • SQL Server 2008 R2

  • SQL Server 2005

Community Additions

ADD
Show:
© 2014 Microsoft