Database server migration

Products

• Information Centric Analytics

Issue/Introduction

This document outlines the process for pointing the Information Centric Analytics (ICA) application to a RiskFabric database that has been migrated with its ancillary components to a new server while leaving the application and cube in place. This procedure assumes the database server's hostname will change. If the hostname will remain the same, no configuration changes are needed.

ICA's footprint on the database server includes: the RiskFabric database; data source data warehouses; SQL Server Agent jobs and proxies; linked server connections; and Database Utilities. This document does not include a procedure for deploying a new database, nor does it address requirements for re-creating all necessary components on a new server.

Environment

Version : 6.x

Resolution

After replicating the RiskFabric database components to the new server, the RiskFabric site's connection string must be updated in Internet Information Services (IIS) to point to the new server name or IP address. The connection string in the RiskFabric OLAP cube's data source definition on the Analysis Services (SSAS) server must also be updated. To make these changes, follow these procedures:

Site (IIS)

1. Open Internet Information Services (IIS) Manager
2. In the Connections pane, navigate to Application Pools
3. Right-click the RiskFabricAppPool and select Stop
4. In the Connections pane, navigate to <server_name> > Sites > RiskFabric
5. In the Actions pane under the Manage Website heading, click the Stop button
6. Open Windows Explorer
7. Navigate to the following folder:

   <ICA_install_path>\Risk Fabric Server Web

   The default installation path is:

   %SystemDrive%\Program Files\Bay Dynamics\Risk Fabric Server Web

8. Open the file following file using a text editor run as an administrator:

   web.config

9. Edit the Data Source in the connection string to point to the new database server and instance (if the default instance is not used):

   <configuration>
     <configSections>
     </configSections>
     <connectionStrings>
       <add name="RiskFabric.Web.Properties.Settings.DatabaseConnectionString" connectionString="Data Source=<server[\instance]>;Initial Catalog=RiskFabric;Integrated Security=SSPI;" />
     </connectionStrings>

10. Save and close the file
11. Open Internet Information Services (IIS) Manager
12. In the Connections pane, navigate to <server_name> > Sites > RiskFabric
13. In the Actions pane under the Manage Website heading, click the Start button
14. In the Connections pane, navigate to Application Pools
15. Right-click the RiskFabricAppPool and select Start

Cube Data Source (SSAS)

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
4. Right-click RiskFabric and select Properties
   The Data Source Properties window opens
5. Select the Connection String value and click the ellipsis to edit the string
   The Connection Manager window opens
6. In the Server name field, enter the new SQL server hostname or IP address
7. Under the heading Connect to a database, select the RiskFabric database in the field labelled Select or enter a database name
8. Click the OK button to save these changes and close the Connection Manager window
9. Click the OK button to close the Data Source Properties window

Miscellaneous

The Active Directory Connector Utility and other data source import utilities also contain connection strings pointing to the database server, but these utilities are typically installed on the database server and use a relative path to point to the data source.