Viz Mosart Administrator Guide

Version 3.8.1 | Published January 22, 2018 ©

Upgrading mosarttemplatedb Manually

The task of upgrading the database consists of running change scripts that have been added since the last upgrade (or installation).

When doing this manually, the installer should keep track of which scripts that have been previously run.

Care has been taken to construct the scripts in such a way if the installer accidentally runs the same script twice, it either has no effect or produces an error message.

To upgrade the Viz Mosart Database, perform the following:

  1. Make sure mosarttemplatedb has been selected
    This is done by clicking it in the Databases tab

  2. Decide which script is the first that has not been run on a previous installation or upgrade.
    If in doubt, it is better to run a script that has been run before, than to skip a script

  3. For each script, for example Db04Change….sql and above, complete the following steps:

    1. Choose the Import tab

    2. Click the Browse button

    3. In the dialogue box, choose the script you wish to run, for example: %ProgramFiles%\Mosart Medialab\Mosart Server\Sql\Db04Change….sql

    4. Make sure the other settings in the Import tab have the following values:

    • Character set of the file: utf8

    • Format of imported file: SQL

    • SQL compatibility mode: NONE

    • Do not use AUTO_INCREMENT for zero values: Checked.

    1. Click the Go button