Migrating Monitoring Server data from a test environment
Migration of Monitoring Server from a test environment to a production environment is similar to the operation outlined in Backing up and restoring Monitoring Server databases.
Either Office SharePoint Server 2007 or Windows SharePoint Services must be installed in order to successfully install and use Monitoring Server. The terms Windows SharePoint Services and SharePoint Services are used collectively in PerformancePoint Server documentation to refer to Office SharePoint Server 2007 and Windows SharePoint Services 3.0.
Install Monitoring Server on the target computer
Before installing the Monitoring Server on the target computer, confirm that you have successfully completed the steps in Backing up and restoring Monitoring Server databases.
Launch Monitoring Server Configuration Manager.
Specify the imported database on the target instance of Microsoft SQL Server 2005 by clearing the Monitoring System Database check box in the configuration wizard. Click Next.
Specify the name of the database you have exported.
Using Notepad, update the Web.config file on the target computer to match the previous ConnectPerUser and CustomData settings on the source:
<add Key=”BPM.ServerConnectionPerUser” value=”False” />
<add Key=”BPM.UseASCustomData” value=”False” />
Use Dashboard Designer to export the existing dashboards to the Windows SharePoint Services server installation.