Relocating the Monitor ERP Server

This instruction describes relocation of Monitor ERP Server with SQL Anywhere to a new server computer.

Preparations

If you cannot perform the relocation by yourselves, the Monitor Support Center offers installation help for Monitor ERP, charged on an ongoing basis. There are different prices for daytime, evenings or weekends. We will then create a remote control session and perform the relocation. Program for the remote control session can be downloaded from our website https://www.monitorerp.com/mos.

  1. Order a server relocation package for Monitor ERP Server from the Monitor Support Center. This package contains installation files for server and client, certificate file, and instructions (for example, this instruction).
  2. When you have received the package you can perform an installation of Monitor ERP Server on the new server computer, see below.
  3. Firstly, make sure all users have shut down their Monitor ERP clients.
  4. Then you should open Services in Windows on the old server computer and shut down the service SQL Anywhere - [server name] (for the database engine). Also deactivate the service making it impossible for it to restart, for example, if the server computer is restarted. To deactivate, change the Startup type of the service from Automatic to Disabled.

Installation on the new server computer:

  1. Start the installation according to the instruction called Install Monitor ERP Server which was included with the installation files, and follow the steps in the initial items.
  2. When you reach item 7 in the installation you select Install an existing environment. Then click Next.
  3. In the next step you select your existing environment called Production and click Next.
  4. The following steps should be taken according to the instruction called Install Monitor ERP Server.

Copy files from the old server computer:

  1. Create a backup of the file called MonitorCompanyConfiguration.json in the Monitor ERP System AB folder on the new server computer. You find this file in the path where you installed Monitor ERP Server. Save the backup copy in a different folder.
  2. Then you should copy the same json-file from the old server computer to the new server computer. Select to overwrite the existing file on the new server computer.
  3. Open the file on the new server computer using a text editor and change the "SqlAnywhere" server name in "ConnectStrings" and also the file paths in "DatabaseDirectory" and "BackupDatabaseDirectory", making them correspond with server name and paths for the new server computer. See the highlights in yellow in the image below.
  4. Shut down the service called SQL Anywhere - [server name] (for the database engine) on the new server computer.
  5. Copy both the Databases folder and the DatabaseBackup folder from the old server computer to the new server computer. Select to overwrite the existing Databases folder on the new server computer. You find the folders via the path where the databases are installed on the old and the new server computer, respectively.
  6. Start the service for the database engine on the new server computer.
  7. In the MONITOR Installation Manager in Windows on the new server computer, you should now create and schedule backup tasks and copying tasks of test companies, making the tasks correspond to how it is configured on the old server computer. Make sure that the path to the folder for database backups is correct in the backup tasks you create on the new server computer.
  8. If you have folders with linked files on the old server computer, you should copy these to the new server computer.
  9. Update the file paths in the Paths procedure in Monitor ERP on the new server computer. If the paths lead to folders on the old server computer, they should be changed so that the paths go to the corresponding folders on the new server computer.

Reinstall Monitor ERP clients

  1. Uninstall the Monitor ERP client on the users' computers.
  2. Install the Monitor ERP client again on the computers, by using the installation file MONITOR Client Setup.exe. Follow the instruction called Install Monitor ERP Windows client available in the server relocation package.
  3. Start the Monitor ERPclients and make sure that everything is working as it should.