Share
 
 

Updating a Workgroup Database in SQL Server

The following is checklist for the update process of a Workgroup Database in SQL Server.

Note: The update scripts for a SQL Server database will always update by a single major version number e.g. 2023.;0 to 2023.1, or 2023.1 to 2023.2.. To update between non-consecutive major version numbers, all intermediate scripts must be run in the correct order.

From version 2023.1 you can use the software whilst using older database versions from version 2023.0 and later. Therefore you do not necessarily have to update the databases when upgrading to a new version of the software, though some functionality may be unavailable. Equally you can upgrade the software to a later database version which is not the current one. As with updating to the current format it is necessary to run the scripts in order.

  1. Download the appropriate update script(s) from the Autodesk website (or from the InfoWorks Workgroup Server installation directory for versions prior to 8.0). Make sure that you have the correct scripts for your application. Either:
    • ICM/ICMLive/InfoNet
    • WS Pro/IWLive Pro/DemandWatch Pro
  2. The script names identify the products and the from and to versions of the update process, e.g.

    SQL_update_from_ICM75IN175_to_ICM80IN180.sql

    Note: No manual editing of the update scripts should be required.
  3. Using SQL Server Management Studio, run the appropriate update scripts in turn to update from the current version number to the desired version number. Check that no errors are reported.
  4. Connecting to the database using the Workgroup client should tell you that a subversion update is required. Allow the subversion update to proceed.
  5. The update is now complete.

Was this information helpful?