Update a Database

When you receive a new version of ICMLive Operator Client, your databases may need to be updated so you can access all new features included in the software. It is recommended that you backup your existing database before you update to a new version. When a database is updated, you, or any other users, will not be able to use it in an earlier version of ICMLive Operator Client.

Oracle or SQL Server databases

If the software version you are updating includes changes to the database tables and fields used by ICMLive Operator Client, the SQL Server and Oracle databases may need to be updated. A message will be displayed informing you that you must manually update the databases using a script.

If you do not update every time you are asked to, you will have to run several scripts in the correct order to update a database.

The process to update an Oracle or SQL Server database requires running scripts on the Oracle/SQL Server server. Full instructions on updating these databases can be found in the Workgroup Server Administration Guide.

Standard on-premise databases

A standard workgroup or standalone database are updated from within ICMLive Operator Client.

Note: You must ensure that there are no users accessing the database before you attempt to update it.

Update a selected database to a specific database version

This method lets you choose which database is to be updated and what version of the database it is to be updated to.

To update a workgroup database

1. Select OpenOpen/Create database from the File menu.

   The Open/Create dialog is displayed.

2. Click the Workgroup image. The Open/Create database dialog closes and the Open Workgroup Database dialog is displayed.

   In this dialog:

3. Enter the Server name and Server port in the Workgroup Data Server section of the dialog.
4. Click Connect. The Status field indicates whether or not a connection is established. A message will also be displayed if it is not possible to connect to the server, and you may need to ask your system administrator for assistance.

   When connected:

5. If the database belongs to a group, select the group from the Group dropdown. This restricts the entries in the Database dropdown list to those that belong to the selected group.
6. Select the required database from the Database dropdown. If no Group is selected, the names of all available databases, including the name of the group they belong to, if applicable, will be displayed in the list.
7. From the Update to dropdown, choose which version of the database the selected database is to be updated to.
8. Click OK. The selected workgroup database is updated to the specified version.

To update a standalone database

1. Select OpenOpen/Create database from the File menu.

   The Open/Create dialog is displayed.

2. Click the Standalone image. The Open/Create database dialog closes and the Open Standalone Database dialog is displayed.

   In this dialog:

3. Click Browse. This displays a standard Windows Open dialog.
4. Choose the database file (with an extension of .icmm) and then click Open. The Open dialog closes and the name of the selected standalone database is displayed in the Open Database dialog.
5. From the Update to dropdown, choose which version of the database the selected database is to be updated to.
6. Click OK. The selected standalone database is updated to the specified version.