Checking Your Database Integrity

Borehole Manager | File | Check Database Integrity

Use this tool to compare the contents of your current project database against the general program data dictionaries, to see a report of the items that are not in synch and to fix all those that it can.  This can be helpful in the event that fields have been added to one of your projects and you re-open another project and the older database no longer matches the modified data dictionaries.

! This tool checks your database structure, not the data contents. 

See also:

• Checking Data Integrity which does both a database check and a data check
• SQLite | Check DB File Integrity which (a) is specific to SQLite databases and (b) checks the database at a file level to ensure it's a valid SQLite database
  
  

Step-by-Step Summary

1. Access the Borehole Manager as necessary.
2. Open the project to be checked.
3. Select the File | Check Database Integrity command.

The program will scan your project database and compare its structure to the current data dictionaries.  It will fix any discrepancies that it can and it will create a report summarizing the status and display it in a text window.

Back to Maintaining your Database

RockWare home page