A Database Utility program is available that has four functions:-

• Making a back-up copy of a database.
• Database reorganization, to remove the unused space that accumulates in Pedigree Software's databases after a lot of data entry and editing.
• Creating a copy of a database as one of a different size-type, for example, name.ped to name.pdg.
• Database repair, when PediTree cannot open a database, or experiences difficulties in Check DB or GEDCOM export.

The Database Utility is available for download here, as an installer (version 2.5.0, 2.6Mb). Once downloaded, double-click on the file to install the utility program and its help-file. Entries for the program and its on-line help are added to your Start menu under Start > Programs > Pedigree. See the on-line help for further information.

To reorganize a database, proceed as follows:-

1. Close PediTree.
2. Run the Database Utility and make a back-up copy of the database.
3. Check and reorganize the database, then exit the utility.
4. Open the database in PediTree.
5. Run File > CheckDB to check that all is well.
6. Close PediTree.
7. Re-run the Database Utility and remove the pre-reorganize version of the database that it retains.

The steps to be taken in repairing a database are documented in the on-line help. They are:-

1. Run the Database Utility and make a back-up copy of the faulty database.
2. Inspect the database and erase any faulty records reported. Then use Reorganize on the error-free database to correct its un-used space records. Exit the Utility.
3. Open the database in PediTree. Confirm PediTree's request to fix any indexes.
4. In Update mode, run File > CheckDB to report and correct any errors.
5. You can now add any missing records and delete any blank records corresponding to deleted records in the old database. (These will appear at the beginning of standard indexes.)
6. Re-run the Database Utility and remove the pre-reorganize version of the database that it retains.

If you have need to use this tool to repair a database, please let Colin Liebenrood know that you have done so. We need to gauge its usefulness and how frequently it is needed.

Version 2.4.5: one warning changed to error (for Pedigree users); layout tolerant of text-size changes in Win 7 and later; fixed a bug when processing more than one database in a single session.

Version 2.4.4 fixed an issue with a massively-corrupt database.

Version 2.4.3 fixes issues with installation and use under Win 7 64-bit.

The following changes were made between versions 2.3.0 and 2.4.2.

• Display of stored data, as a percentage of maximum capacity. This may appear as a single figure, such as 49%, or a dual figure such as 55%/49%. This latter form shows both the current value, with unused space, and the value that would apply if the database was reorganised.
• The ability to process databases that have one or more space-files missing. These missing files can be re-created by using the Reorganise process.
• Additional hints of the actions that need to be taken to repair a faulty database.
• On the Maintenance sheet, a display of both the number of records and data occupancy, as a percentage of the total allowed. These figures can be displayed for other size-types (1,3,4,6 or 9 Mb) that can accomodate the data present.
• The ability to create a copy of the database, but having a different size-type.
• A number of improvements and fixes affecting the displays and other functions.