Updating master databases

Closed

When you receive a new version of InfoWorks WS Pro, master 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 master database is updated, you, or any other users, will not be able to use it in an older version of InfoWorks WS Pro.

This topic does not apply to SQL Server or Oracle databases, for which see Updating SQL Server or Oracle databases.

In most situations, updating of master databases will be automatic. However, manual updates may be required if the changes are major.

Important

You must ensure that there are no users accessing a master database before you update it manually or allow it to be updated automatically.

Automated updates

Automated updates will be initiated if it is detected that, after updating, the master database will remain backwards compatible. That is, if the changes will not prevent users of previous versions of InfoWorks WS Pro from using the master database.

When you open a master database that qualifies for an automated update, the Update To Later Database Sub-version dialog is shown. In this case, to update the master database, click OK.

Users will be able to use the database as normal after the change.

Automated updates occur whether or not the user is an administrator.

If the master database cannot be updated automatically, a message will be shown when you first try to use it with a new version of the product, and you will have to update the master database manually.

Updating a master database manually

If the changes required are large enough that the database will no longer be usable in previous versions of InfoWorks WS Pro, you must carry out a manual update.

When you open or attempt to use a master database that needs a manual update, you will see a message saying so, and you will be able to do nothing more with the master database until it is updated.

InfoWorks WS Pro lets you choose which master database is to be updated and what version of the database it is to be updated to.

To update a master database manually:

  1. Select File | Database update| Update master database.

    This displays the Open Master Database dialog.

  2. Connect or browse to the master database that you want to update.
  3. In the Update to drop-down menu, select which version of the database that you want this master database to be updated to.
  4. Click OK.

    You will see a message describing the process. InfoWorks WS Pro creates a copy of the database before updating. It then replaces the original with the updated version if the update is successful.

  5. Click OK to clear the message.
  6. Choose where to save the temporary file, then click Save.

    The process will continue automatically.

    You will see a progress bar. When this disappears, you will see no more messages unless the process has failed.


About the master database

Creating a new master database

Opening a master database

Opening another master database

Deleting a master database

Updating SQL Server or Oracle databases

Copying data within and between databases

Copying global preferences

Update To Later Database Sub-version dialog

Open Master Database dialog