This article provides best practices for migrating IT Analytics and all installed content packs in the event the underlying SQL server is moved. These steps are only specific to IT Analytics with respect to the migration of SQL Server Analysis Services and SQL Server Reporting Services. This article does not detail information regarding migrating Altiris ITMS and/or the Symantec_CMDB. Depending on the way you have IT Analytics configured or if any customizations have been implemented, you will need to follow one of the following scenarios detailed below.
Choose this scenario if you have not made any custom modifications to the default cube set within IT Analytics (i.e. no custom cubes have been created or modified). This scenario follows the process for installing and configuring a new instance of IT Analytics.
Choose this scenario if you have modified the default IT Analytics cubes by adding data classes through the IT Analytics Cube Extension Utility.
Choose this scenario if you have modified or created new cubes outside of the Cube Extension Utility (i.e. within Business Intelligence Development Studio or another development tool).
In addition to the scenarios listed above, follow these steps only to migrate previously created custom reports in SQL Reporting Services from the old server to the new server.