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.
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 update
Update 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
- Select Open
Open/Create database from the File menu.
The Open/Create dialog is displayed.
- Click the Workgroup image. The Open/Create database dialog closes and the
Open Workgroup Database dialog is displayed.
In this dialog:
- Enter the Server name and Server port in the Workgroup Data Server section of the dialog.
- 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:
- 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.
- 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.
- From the Update to dropdown, choose which version of the database the selected database is to be updated to.
- Click OK. The selected workgroup database is updated to the specified version.
To update a standalone database
- Select Open
Open/Create database from the File menu.
The Open/Create dialog is displayed.
- Click the Standalone image. The Open/Create database dialog closes and the
Open Standalone Database dialog is displayed.
In this dialog:
- Click Browse. This displays a standard Windows Open dialog.
- 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.
- From the Update to dropdown, choose which version of the database the selected database is to be updated to.
- Click OK. The selected standalone database is updated to the specified version.
To update a cloud database
- Choose Open
Open/Create database from the File menu. The Open/Create dialog is displayed.
- Click the
Cloud image. The Open/Create database dialog closes and the
Open Cloud Database dialog is displayed.
In this dialog:
- Select the name of the database you want to update from the Database dropdown.
- From the Update to dropdown, choose which version of the database the selected database is to be updated to.
- Click OK. The selected cloud database is updated to the specified version.