6.2 Upgrading Considerations

Before upgrading to Analysis Center 3.0 or later, you must consider the following:

  • Apply either the Hotfix 7015655 or the Hotfix 2.9.0.3 on the Analysis Center 2.9 setup.

  • If you choose to upgrade Analysis Center and the SQL Servers that host Analysis Center components, you must first upgrade Analysis Center and then upgrade the SQL Servers. If you have Data Warehouse, Configuration database, AC_OLAP database, and Data Extension in a distributed environment, then you must ensure that all the SQL Servers hosting these components are on the same version.

  • If Data Warehouse and Data Mart are distributed on different versions of SQL Server, you must install the SQL Server Client Tools on the Data Warehouse computer. The version of the Client Tools must match the SQL Server version of the Data Mart computer:

    • SQL Server version later than 2005 is installed on the Data Mart computer: On the Data Warehouse computer, install the following SQL Server Client Tools located under Shared Features in the SQL Server setup program:

      • Client Tools Connectivity

      • Client Tools SDK

      • SQL Client Connectivity SDK

    • SQL Server 2005 is installed on the Data Mart computer: On the Data Warehouse computer, install the following SQL Server 2005 Client Tools located under Client Components in the SQL Server 2005 setup program:

      • Connectivity Components

      • Legacy Components

      • Management Tools

      • Software Development Kit

  • Back up the AC_Warehouse and AC_Configuration databases on Data Warehouse and all the Data Mart computers. For more information about backing databases, see Section 6.3, Backing Up Databases Before Upgrade.

  • To upgrade Data Warehouse in a SQL Server cluster environment, perform the following steps:

    1. Upgrade Data Warehouse on the active node.

    2. Upgrade the Data Warehouse on the second node, which is now the passive node.

  • Keep a note of the following:

    • The locations of the existing databases, for example, AC_OLAP, AC_Warehouse, location of SQL Server Analysis Services, and location of data sources.

    • The URL of AC Web Service and SQL Server Reporting Services.

    • The location of the NRQConfig database.

    • The user names that are used to access the above databases and the services.