Server Migration FAQ

Useful information and common steps referenced by the Server Migration Guide.

+ More

Table of Contents

Overview How to Determine Which Databases Are Used by ESMP Installation Databases Workflow Monitoring and Instance Store Database How to Determine Application Version How to Determine Service Account How to Determine Installation Directory

Overview

This page provides useful information and common steps that are referenced in the Server Migration Guide.

How to Determine Which Databases Are Used by ESMP Installation

Databases

The following settings are stored in the <ROOT>\bin\sps.config configuration file:

  1. Main Database
<update4u.SPS.DataLayer
    databaseConnectString="data source=<DB_SERVER>;initial catalog=<MAIN_DATABASE>;integrated security=True"
    ...
/>
  1. File Storage Database
<update4u.SPS.DatabaseFileStorage
     connectionString="Data Source=<DB_SERVER>;Initial Catalog=<MAIN_DATABASE>;Integrated Security=True"
     ...
 />

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table, update4u.SPS.DatabaseFileStorage-connectionString Key (see also, Advanced System Settings).

 
  1. History Database
<update4u.SPS.History
    databaseConnectString="Data Source=<DB_SERVER>;Initial Catalog=<HISTORY_DATABASE>;Integrated Security=True"
    ...
/>

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table, update4u.SPS.History-databaseConnectString Key (see also, Advanced System Settings).

 
  1. Data Warehouse Database
<update4u.DataWarehouse
    databaseConnectString="Data Source=<DB_SERVER>;Database=<DW_DATABASE>;Integrated Security=True"
    ...
/>

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table, update4u.DataWarehouse-databaseConnectionString Key (see also, Advanced System Settings).

 
  1. Analysis Database
<update4u.DataWarehouse
    cubeConnectionString="data source=<DB_SERVER>;integrated security=True;Database=<ANALYSIS_DATABASE>" 
    ...
/>

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table, update4u.DataWarehouse-cubeConnectionString Key (see also, Advanced System Settings). 

 
  1. Reporting Services
<update4u.SPS.ReportingServices
    server="http://<DB_SERVER>/ReportServer"
    rootFolder="/<ROOT_FOLDER>"
    ...
/>

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table,  update4u.SPS.ReportingServices-server Key (see also, Advanced System Settings).

 

Workflow Monitoring and Instance Store Database

The following settings are stored in the <ROOT>\svc\Config\ConnectionStrings.config configuration file:

<connectionStrings>
    <add connectionString="Data Source=<DB_SERVER>;Initial Catalog=<MONITORING_DB>;Integrated Security=True" name="M42MonitoringConnectionString" />
    <add connectionString="Data Source=<DB_SERVER>;Initial Catalog=<INSTANCESTORE_DB>;Integrated Security=True" name="M42PersistenceConnectionString" />
</connectionStrings>

How to Determine Application Version

The current version is available on the Global System Settings preview page of the Administration application.

The version number consists of several parts, for instance:

12.0.5.3449 where

  • 12 - Major version
  • 0 - Minor version
  • 5 - Revision
  • 3449 - Build version

How to Determine Service Account

The service account is stored in the <ROOT>\bin\sps.configfile:

<update4u.SPS.Console
    ...
    serviceAccount="="<DOMAIN>\<USER>"
    ...
/>

Starting from DWP v.12.1.1 these settings were moved from SPS.config file to the PDRDwpConfigurationClass database table,  update4u.SPS.Console-serviceAccount Key (see also, Advanced System Settings).

 

How to Determine Installation Directory

By default, the ESMP is installed under C:\Program Files (x86)\Matrix42\Matrix42 Workspace Management.

To determine the installation directory, perform the following steps:

  1. Start Registry Editor: from the command line run regedit.exe.
  2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Matrix42.
  3. Check the value of the InstallLocation key.
faq migration

Related Articles