Upgrading the SQL Anywhere Monitor and migrating resources and metrics

Caution

Uninstalling the Monitor removes the application, as well as resources and collected metrics.

If you want to preserve your current Monitor resources and metrics, you must:

  1. Install a new version of the Monitor.

  2. Migrate the resources and metrics.

  3. Uninstall the older version of the Monitor.

You can use the Migrator utility to migrate the resources and metrics from one Monitor to a newly created Monitor.

 To migrate the Monitor resources and data using the Migrator utility
  1. Copy the existing Monitor database file, samonitor.db. For example to migrate the 11.0.1 Monitor, copy the following file:

    C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Monitor\samonitor.db
  2. Install the new Monitor. Run the setup.exe file from the Monitor directory on your installation media, and follow the instructions provided. When the installation finishes, stop the new Monitor (if it is running).

    Note

    Only one version of the Monitor can run on a computer at a time.

    When you install the version 12.0.0 Monitor on a computer where a version 11.0.1 Monitor is running, the install stops the version 11.0.1 Monitor.

  3. At a command prompt, run the Migrator utility. Use the following table to determine the location of the Migrator utility.

    Operating system Monitor type Default location of the Migrator utility.
    Windows Monitor Developer Edition C:\Program Files\SQL Anywhere 12\run_migrator.cmd
    Monitor Production Edition C:\Program Files\SQL Anywhere Monitor 12\run_migrator.cmd
    Linux Monitor Developer Edition /opt/sqlanywhere12/bin32/run_migrator.sh
    Monitor Production Edition /opt/samonitor12/bin32/run_migrator.sh or /opt/samonitor12/bin64/run_migrator.sh

    Run the Migrator utility with the following options:

    • -c   Specifies that only resources and configuration settings are migrated. By default, both the resources and collected data are migrated.

    • -t temporary-directory   Specifies the directory for temporary files. By default, the temporary files are created in the same directory as the run_migrator file.

      Note

      The Monitor Migrator creates temporary files that are deleted at the end of the migration process. Use the -t option to specify a directory for these temporary files. The temporary files take up a similar amount of space as the version 11.0.1 Monitor database file. Ensure that the specified directory has sufficient space.

    • source-filename   Specifies the path and file name to the old Monitor file from which the data is unloaded. For example, the path to the version 11.0.1 samonitor.db file.

    • destination--filename   Specifies the path and file name to the new Monitor file where the data is reloaded. For example, the path to the version 12.0.0 samonitor.db file.

    For example:

    C:\Program Files\SQL Anywhere 12\run_migrator.cmd -t c:\monitorbackup c:\Program Files\SQL Anywhere 11\Monitor\samonitor11.db C:\Program Files\SQL Anywhere 12\Monitor\samonitor12.db

The default locations of the version 11.0.1 Monitor and version 12.0.0 Monitor database files are listed in the following table:

Operating system Monitor type 11.0.1 directory 12.0.0 directory

Windows XP

Monitor Developer Edition
C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Monitor\samonitor.db
C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Monitor\samonitor.db
Windows XP Monitor Production Edition
C:\Documents and Settings\All Users\Documents\SQL Anywhere 11 Monitor\samonitor.db
C:\Documents and Settings\All Users\Documents\SQL Anywhere 12 Monitor\samonitor.db
Windows Vista and later versions of Windows Monitor Developer Edition
 C:\Users\Public\Documents\SQL Anywhere 11\Monitor\samonitor.db
C:\Users\Public\Documents\SQL Anywhere 12\Monitor\samonitor.db
Windows Vista and later versions of Windows Monitor Production Edition
 C:\Users\Public\Documents\SQL Anywhere 11 Monitor\samonitor.db
C:\Users\Public\Documents\SQL Anywhere 12 Monitor\samonitor.db
Linux Monitor Developer Edition
/opt/sqlanywhere11/samonitor.db
/opt/sqlanywhere12/samonitor.db
Linux Monitor Production Edition
/opt/samonitor11/samonitor.db  
/opt/sqlanywhere12/samonitor.db