Migrate the Monitor resources and data using the Migrator utilityYou can use the Migrator utility to migrate the resources and metrics from one Monitor to a newly-created Monitor.
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:
Install a new version of the Monitor.
Migrate the resources and metrics.
Uninstall the older version of the Monitor.
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 |
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 12.0.1 Monitor on a computer where a version 11.0.1 Monitor is running, the install stops the version 11.0.1 Monitor.
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\Bin32\run_migrator.cmd |
| Monitor Production Edition | C:\Program Files\SQL Anywhere 12\Bin32\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.
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.1 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.1 Monitor database files are listed in the following table:
| Operating system | Monitor type | 11.0.1 directory | 12.0.1 directory | ||||
|---|---|---|---|---|---|---|---|
|
Windows XP |
Monitor Developer Edition |
|
|
||||
| Windows XP | Monitor Production Edition |
|
|
||||
| Windows Vista and later versions of Windows | Monitor Developer Edition |
|
|
||||
| Windows Vista and later versions of Windows | Monitor Production Edition |
|
|
||||
| Linux | Monitor Developer Edition |
|
|
||||
| Linux | Monitor Production Edition |
|
|
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |