Navigation:  Projetex Administration > Database Administration >

Run Update Script

Previous pageReturn to chapter overviewNext page

In some cases, when you update your Projetex Server Administrator or Projetex Workstation, database needs be updated as well. Usually database version is automatically updated during Projetex Server setup, however there may be exceptions. In this case database can still be updated manually by running a database update script.

Update scripts are always installed together with Projetex Server Administrator and can be found in C:\Program Files\AIT\Projetex 9\Projetex Server\DBUpdates\ folder in the form of .PTU files.

To update database using a database update script:

1. Turn your database offline by clicking Go Offline button.

2. Click Run Update Script button from the Database tab of the Projetex Server Administrator.

3. Locate the script which updates your current database version to a next version. Current database version is displayed in Database Version: string on the Database tab of Projetex Server Administrator. Repeat update operation until you have the most current database version.

Example:

Installed database version is 8.91.0 and software update requires 8.93.0 database version. In this case you need to consecutively run two updates (first dbx91to92.ptu and then dbx92to93.ptu). Update files are not necessarily updating from the one number to the next.

Note: Projetex Server Administrator does mandatory backup before each database update operation, for maximum security of data in case anything goes wrong during the update.

Note: You can run Update Script command in Offline mode only.