Prior to version 1.0.6 Bike Logs was supplied with a maintenance tool so that database structure changes could safely be made without you having to re-enter all your data. The maintenance tool could perform a number of tasks, but it was most commonly used for changing the structure of the database (the schema).

Important: This article only applies to Bike logs versions 1.0.5 and earlier. If you are using version 1.0.6 and later the information below is irrelevent as Bike Logs is capable of automatically updating itself and the maintenance tool is no longer supplied. Schema downloads are no longer available as Bike Logs will generate the schema file itself as and when required.

Occasionally a new feature added into Bike Logs will require the database, which stores all of your information, to be modified to support the new program changes.  Thankfully, modifying the database is not something will occur very often but, when a database update is required, Bike Logs will usually not operate until it has been done.

To update your database you will need to download the latest schema configuration file from the downloads page so that the maintenance will know what changes need to be made.

To update the database:

1. Copy the bikelogs.schema file to the Bike Logs database folder, this will normally be 'C:\Program Files\RedFox\Bike Logs' unless you chose a different folder during the original installation.
    
2. Run the DataTool program stored in the same folder, it will look like the picture opposite.
    
3. Click on the 'File' menu then select 'Load Schema', a file selection window will appear, use it to select the schema file you copied into this folder in step 1.
    
4. Click on the 'Tools' menu then select 'Update Current Database', you will be prompted if you are sure you want to update the database, click 'Yes' and the update process will begin.
    
5. When the update has completed a colour coded report will display in a web browser window displaying the results of the update. Changed items be blue and any errors will be red, as per the example below.
    

• The maintenance tool will make a backup copy of the database before it attempts to make any changes. However, it is still recommended that you make your own backup of the database before using any of the tool's facilities. 
   

 
Update Report

The picture opposite is a sample of the report file generated by the maintenance tool.

The report shows the status of each field identified in the schema and the result of any updates attempted.

Blue fields indicate an update was required and it was successful.

Red fields indicate an update was required but it was unsuccessful.

Green fields indicate that no update was required.