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 21:17] – Version update Colin Liebenrood | utilities:dbutil [2013/04/01 18:53] – [Pedigree Database Utilities] 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 two 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. | ||
- | |||
- Make a back-up copy of the database. | - Make a back-up copy of the database. | ||
- | |||
- Use the Database Utility to check and reorganize the database. | - Use the Database Utility to check and reorganize the database. | ||
- | |||
- Open the database in PediTree. | - Open the database in PediTree. | ||
- | |||
- Run **File > CheckDB** to check that all is well. | - Run **File > CheckDB** to check that all is well. | ||
- | |||
- 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. | ||
- | |||
- Use the Database Utility to inspect the database and erase any faulty records reported. Then use Reorganize on the error-free database to correct its un-used space records. | - Use the Database Utility to inspect the database and erase any faulty records reported. Then use Reorganize on the error-free database to correct its un-used space records. | ||
- | |||
- Open the database in PediTree. Confirm PediTree' | - Open the database in PediTree. Confirm PediTree' | ||
- | |||
- In Update mode, run **File > CheckDB** to report and correct any errors. | - In Update mode, run **File > CheckDB** to report and correct any errors. | ||
- | |||
- If you have used the Database Utility Reorganize process, then | - If you have used the Database Utility Reorganize process, then | ||
- | |||
- 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.) | ||
- | |||
- 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. | ||
- | |||
- If, however, you have **not** used the reorganize process, then **do not** add back any missing records at this stage, but proceed as follows:- | - If, however, you have **not** used the reorganize process, then **do not** add back any missing records at this stage, but proceed as follows:- | ||
- | |||
- Use **File > Save As GEDCOM > GEDCOM 4 Pedigree** to export the whole database. Say ' | - Use **File > Save As GEDCOM > GEDCOM 4 Pedigree** to export the whole database. Say ' | ||
- | |||
- Use **File > NewDB** to create a new empty database, opting to keep the Indexes | - Use **File > NewDB** to create a new empty database, opting to keep the Indexes | ||
- | |||
- Switch to Update mode, then use **File > Import > GEDCOM** to import the GEDCOM file exported above. | - Switch to Update mode, then use **File > Import > GEDCOM** to import the GEDCOM file exported above. | ||
- | |||
- 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