utilities:dbutil
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
utilities:dbutil [2012/07/12 23:17] – [Repair Process] PUGwiki Admin | utilities:dbutil [2013/04/01 18:53] – [Pedigree Database Utility] Colin Liebenrood | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Pedigree Database | + | ====== Pedigree Database |
- | + | ||
- | + | ||
- | + | ||
- | A Database Utility program is available that has two functions: | + | |
+ | A Database Utility program is available that has three functions:- | ||
* Database reorganization, | * Database reorganization, | ||
- | + | * 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. | * Database repair, when PediTree cannot open a database, or experiences difficulties in Check DB or GEDCOM export. | ||
- | + | The Database Utility is available for {{: | |
- | + | 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 | |
- | The Database Utility is available for {{: | + | |
- | + | ||
- | 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 | + | |
- | ormation. | + | |
- | + | ||
==== Reorganization ==== | ==== Reorganization ==== | ||
- | |||
- | |||
To reorganize a database, proceed as follows:- | To reorganize a database, proceed as follows:- | ||
- | |||
- | |||
- Close PediTree. | - Close PediTree. | ||
Line 39: | Line 21: | ||
- Close PediTree. | - Close PediTree. | ||
- Re-run the Database Utility and remove the pre-reorganize version of the database that it retains. | - Re-run the Database Utility and remove the pre-reorganize version of the database that it retains. | ||
- | |||
- | |||
==== Repair Process ==== | ==== Repair Process ==== | ||
- | |||
- | |||
The steps to be taken in repairing a database are documented in the on-line help. They are:- | The steps to be taken in repairing a database are documented in the on-line help. They are:- | ||
- | |||
- | |||
- Make a back-up copy of the faulty database. | - Make a back-up copy of the faulty database. | ||
Line 63: | Line 39: | ||
- 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.) | - 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.) | ||
- When satisfied with the new database, you can delete the old one. | - When satisfied with the new database, you can delete the old one. | ||
- | |||
==== Feedback ==== | ==== Feedback ==== | ||
- | |||
- | |||
If you have need to use this tool to repair a database, **please** let Murray Kennedy and/or Colin Liebenrood know that you have done so. We need to gauge its usefulness and how frequently it is needed. | If you have need to use this tool to repair a database, **please** let Murray Kennedy and/or Colin Liebenrood know that you have done so. We need to gauge its usefulness and how frequently it is needed. | ||
+ | ==== Changes in New Version ==== | ||
+ | The following changes have been made between versions 2.3.0 and 2.4.2. | ||
+ | * Display of stored data, as a percentage of maximum capacity. | ||
+ | * The ability to process databases that have one or more space-files missing. | ||
+ | * 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. | ||
utilities/dbutil.txt · Last modified: 2018/08/30 00:19 by 127.0.0.1