Share
 
 

Update a Database

When you receive a new version of InfoWorks ICM, 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 older version of InfoWorks ICM.

Oracle or SQL Server databases

If the software version you are updating includes changes to the database tables and fields used by InfoWorks ICM, 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 Data Server Administration Guide.

Standard on-premise or cloud databases

A standard on-premise workgroup or standalone database or a cloud database are updated from within InfoWorks ICM.

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

There are two methods for updating a database. These are outlined below.

Update the current database to the latest database version

This method updates the currently selected database to the latest version of the database.

To use this method:

  • Select Database updateUpdate current database to latest version from the File menu. The currently selected cloud, workgroup or standalone database is updated to the latest version.

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.

To update a cloud database

  1. Choose OpenOpen/Create database from the File menu. The Open/Create dialog is displayed.
  2. Click the Cloud image. The Open/Create database dialog closes and the Open Cloud Database dialog is displayed.

    In this dialog:

  3. Select the name of the database you want to update from the Database dropdown.
  4. From the Update to dropdown, choose which version of the database the selected database is to be updated to.
  5. Click OK. The selected cloud database is updated to the specified version.

Was this information helpful?