Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16

 

Upgrading the SQL Anywhere Monitor and migrating resources

Use the Migrator utility to migrate the resources from one Monitor to a newly installed Monitor.

Prerequisites

Caution

Uninstalling the Monitor removes the application, as well as resources and collected metrics. To preserve your current Monitor resources, you must:

  1. Install a new version of the Monitor.

  2. Migrate the resources.

  3. Uninstall the older version of the Monitor.

To avoid unwanted alerts, schedule a blackout period in the SQL Anywhere Monitor for your servers before you shut them down.

 Task
  1. Create a back up copy of the existing Monitor database file, samonitor.db.

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

    Operating system Monitor type version 11.0.1 and 12 directories version 16.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
    C:\Documents and Settings\All Users\Documents\SQL Anywhere 16\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
    C:\Documents and Settings\All Users\Documents\SQL Anywhere 16 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
    C:\Users\Public\Documents\SQL Anywhere 16\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
    C:\Users\Public\Documents\SQL Anywhere 16 Monitor\samonitor.db
    Linux Monitor Developer Edition
    /opt/sqlanywhere11/samonitor.db
    /opt/sqlanywhere12/samonitor.db
    /opt/sqlanywhere16/samonitor.db
    Linux Monitor Production Edition
    /opt/samonitor11/samonitor.db
    /opt/samonitor12/samonitor.db
    /opt/sqlanywhere16/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).

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

    When you install the version 16.0 Monitor on a computer where an older version of the Monitor is running, the install stops the old version of the Monitor.

  3. At a command prompt, run the Migrator utility.

    Run the Migrator utility with the following options:

    • -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 old Monitor database file. Ensure that the specified directory has sufficient space.

    • source-filename   Specifies the path and file name to the old Monitor database file. 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 resources and configuration settings are loaded. For example, the path to the version 16.0 samonitor.db file.

    For example:

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

    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 16\Bin32\run_migrator.cmd
    Monitor Production Edition C:\Program Files\SQL Anywhere 16\Bin32\run_migrator.cmd
    Linux Monitor Developer Edition /opt/sqlanywhere16/bin32/run_migrator.sh
    Monitor Production Edition /opt/sqlanywhere16/bin32/run_migrator.sh

Results

The Monitor is upgraded.

Next

Start the Monitor

 See also