Skip to main content
Matrix42 Self-Service Help Center

Migrating the Entire Application to a New Environment

Overview

This walkthrough provides a step-by-step guide for migrating Matrix42 Software Asset & Service Management to new server environment.

This guide assumes that the application uses the distributed deployment configuration, i.e. a Database Server, where all SQL Server components are located, and an Application Server, where Matrix42 Software Asset & Service Management is installed.

If you need to install a later version of Matrix42 Software Asset & Service Management, you should update the application before migrating it.

Set Up the New Environment

To start the migration process, you should set up the new server environment and install the same version of Matrix42 Software Asset & Service Management on it.

To find out which version is installed, see How to Determine Application Version.

For more information regarding the installation or update processes, please refer to Installation and Configuration and Update.

To simplify the configuration, use the same Service Account and the same database names on new servers.

After the installation make sure that all application services are running. To do it, start Matrix42 Software Asset & Service Management, and then click Administration > Home > System Diagnostics.

Shut Down the Application

Before you start the migration process, shut down the application to avoid data loss. To shut down the application, perform the following steps:

  • Stop the following Windows services:
    • Matrix42 Engine Common
    • Matrix42 Engine Common X86
    • Matrix42 Engine Scheduler
    • AppFabric Workflow Management Service
    • AppFabric Event Collection Service
  • Stop Internet Information Services (IIS)

Back Up the Databases

Perform full backup of the following databases:

  • Main Database (by default M42Production)
  • History Database (by default M42Archive)
  • Warehouse Database (by default M42Warehouse)
  • Reference Database <MAIN DB>_REF (by default M42Production_REF)
  • Workflow Instance Store (by default M42InstanceStore)

There are more databases related to Matrix42 Software Asset & Service Management, such as Workflow Monitoring (M42Monitoring), SSAS Cube (M42AnalysisServices), and Staging databases that are used by Data Providers. However, these databases contain no critical data and can be recreated from scratch at any time. 

For more information about the databases that are used, see How to Determine Which Databases are Used by WPM Installation.

Back Up the Application Files

By default, the application is installed under C:\Program Files (x86)\Matrix42\Matrix42 Workspace Management. In some cases a different path is used. To find out where the application is installed, see How to Determine Installation Directory.

To back up the application files, perform the following steps:

  1. Decrypt the configuration files by executing the following commands from the command line:
%SYSTEMROOT%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/M42Services"
%SYSTEMROOT%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis -pd "connectionStrings" -app "/sps"
  1. Back up the entire installation directory.

Restore the Application Files

To restore the application files, make sure that the application is shut down. For more information, see Shut Down the Application.

Restore the application files on the new Application Server (replace the existing files).

After this step the application should be fully functional, but it still references the old databases.

Restore the Databases

Restore the following databases on the new environment:

  • Main Database (by default M42Production)
  • History Database (by default M42Archive)
  • Warehouse Database (by default M42Warehouse)
  • Reference Database <MAIN DB>_REF (by default M42Production_REF)
  • Workflow Instance Store (by default M42InstanceStore)

Change the Application Configuration

Reconfigure the Application to Use the New Database Server

To reconfigure the Database Server, perform the following steps:

  1. Run Configuration Wizard.
  2. Click Change Configuration > Change Database Server.
  3. Specify New Configuration for the Database Server.
  4. Click Next to apply the configuration.

You can also reconfigure the Database Server manually. In this case you should adjust all connection strings that are defined in How to Determine Which Databases are Used.

Reconfigure the Service Host

Open the <INSTALL DIR>/bin/sps.config file in any text editor and make sure that the settings are correct:

<Matrix42.ServiceLayer
...
servicesHost="localhost"
discoveryHostName="<FQCN>"
appFabricAdminGroup="<DOMAIN>\AS_Administrators"
...
/>

servicesHost: equal to "localhost"

discoveryHostName: fully qualified computer name or domain name that is used to access the Matrix42 Software Asset & Service Management Console. This name should match the SSL certificate of the IIS website on which WPM is installed.

appFabricAdminGroup: Domain group that is used to access the Workflow Monitoring database and the Instance Store database.

By default, the setup uses fully qualified computer name (FQCN) as discoveryHostName and generates a self-signed SSL certificate with the corresponding CN (common name). If you use custom domain name and SSL certificate, then you should migrate the certificate manually and configure it to be used as discoveryHostName.

Verify the Application Configuration

To verify application configuration, run the setup wizard and follow all steps, as during the update. Before you start the update process, you should downgrade the application version:

  1. Open the <INSTALL DIR>/bin/sps.config file in any text editor.
  2. Change the build part of the application version (update4u.SPS.Console-productVersion). For example, if the version is equal to 6.0.1.1155, set it to 6.0.1.1154. For more information, see How to Determine Application Version.
  3. Save the configuration.

To run Matrix42 Software Asset & Service Management Setup in the update mode, run the following command from the command line:

<INSTALL DIR>/bin/Matrix42.Setup.exe –update

Click Launch the update process and follow the wizard steps.

You can skip the Database Backup step by using the Advanced Options.

When the update process is finished, you should diagnose the system. To do it, start Matrix42 Software Asset & Service Management, and then click Administration > Home > System Diagnostics

  • Was this article helpful?