Backup and migration of databases

You are able to choose an external disk which you can store temporary files on when updating. By doing this, database copies are automatically placed on the external disk and you minimize the risk of the system starting will full disk space. The path for the external disk is UpdateBackupPathOverride in the configuration file MonitorCompanyConfiguration.json.

SQL Anywhere

Backup and migration of SQL Anywhere databases, in connection with update of Monitor ERP Server takes place in the following way. This will all take place automatically:

  1. All databases are copied from the regular database directory to the Installation_temp directory under C:\ProgramData\Monitor ERP System G5\. The company configuration file is also copied to the directory.
  2. After this, a migration of the databases to the new version in the temporary directory will be carried out.
  3. After the migration in the temporary directory, the following takes place:
    1. All databases in the regular database directory are moved to the Installation_old directory, under C:\ProgramData\Monitor ERP System G5\.
    2. The migrated databases in the temporary directory are then moved to the regular database directory.
  4. When the Monitor server starts up after the update, the system database and BI database are also migrated.

If migration of the databases should fail for some reason, the entire update is canceled.

PostgreSQL

When PostgreSQL is used, no automatic backup is created before an update. The reason for this is that, during migration, all updates are executed within a single transaction. If anything goes wrong, the changes are automatically rolled back. Without the need for a backup, the entire update process is faster than with the other database solutions.

SQL Server

If the databases run on SQL Server, the update cannot copy or move databases as in the descrption below. The databases will instead be migrated directly on SQL Server. That is why it is important that you first backup the databases in Microsoft SQL Server Management Studio according the Microsoft’s documentation, before you start the update of Monitor ERP Server.