Skip to main content
Matrix42 Self-Service Help Center

Server Migration FAQ

  1. Last updated
  2. Save as PDF

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 DWP 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"
     ...
 />

2. File Storage Database

<update4u.SPS.DatabaseFileStorage
     connectionString="Data Source=<DB_SERVER>;Initial Catalog=<MAIN_DATABASE>;Integrated Security=True"
     ...
 />

3. History Database

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

4. Data Warehouse Database

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

5. Analysis Database

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

6. Reporting Services

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

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:

10.0.3.3033 where

  • 10 - Major version or Product Version
  • 0 - Minor version or Service Pack
  • 3 - Revision or Patch
  • 3033 - Build version

How to Determine Service Account

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

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

How to Determine Installation Directory

By default, the DWP 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.