Upgrading Your Database

The following is the recommended database upgrade procedure. You will need to follow this procedure when you upgrade your software to a higher version with a different database structure (e.g. upgrading from AccuTrack version 7 or 8 to AccuTrack version 9). For the purpose of this procedure, we will assume you are upgrading from AccuTrack version 8 to AccuTrack version 9.

1. Locate your AccuTrack 8 database folder. This is the folder we want to upgrade. If you are not sure where this folder is located, launch AccuTrack 8, go to the System Administration screen, click on "Database" and then on "Database Location" and you will see the path and name of this folder (the default name is "AccuData").
2. Backup your AccuTrack 8 database folder (e.g. AccuData) by making a copy of it.
3. Make sure you are the only one using the AccuTrack 8 database file. The Remote Shutdown screen available via the Database node will help you verify this.
4. Run the database repair utility in AccuTrack 8: From System Administration click on Database and then Repair. You are now ready to upgrade the database.
5. Install AccuTrack 9 using its installation CD on your computer. Select the "Typical" installation option.
6. When the installation is finished, browse the installation folder of AccuTrack 9 with Windows Explorer. The default installation folder for AccuTrack 9 is C:\Program Files\Accu90.
7. You will see a folder called AccuData in AccuTrack 9 installation folder (i.e. C:\Program Files\Accu90\AccuData). This folder contains a blank database. Rename this folder to something like C:\Program Files\Accu90\AccuData_blank
8. Copy the AccuTrack 8 database folder (one you want to upgrade) from the shared network folder to your AccuTrack 9 installation folder (i.e. C:\Program Files\Accu90). Now the "AccuData" folder on your local computer contains the AccuTrack version 8 database.
9. Launch AccuTrack 9. The software will detect the older version database and it will show a message that it is going to upgrade it. The software will then upgrade the database and will display a message when it is finished. The upgrade process should only take a few minutes. If you do not see any errors and get a "success" message, then your database is upgraded.
10. Exit AccuTrack 9.
11. If the upgrade was successful, delete or rename the AccuTrack 8 version AccuData folder on the shared network drive.
12. Copy the database folder and the data dictionary folder - "C:\Program Files\Accu90\AccuData" and "C:\Program Files\Accu90\AccuDic" respectively from your local drive to your shared network drive. You now have version 9 AccuData and DataDic folder on the network.
13. Launch AccuTrack 9 on the local computer and switch the database folder from the local version to the network version by going to the System Administration screen and clicking on Database and thenDatabase Location. Click "Select Path" and browse to select the database folder on the shared network drive. Click on Save and exit AccuTrack. AccuTrack 9 on this computer is now using the shared database folder.
14. To upgrade other computers using the same shared database to version 9, install the AccuTrack 9 software on these computers and then use the Database Location screen to point them to the shared database folder on the network.