User Tools

Site Tools


utilities:dbutil

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
utilities:dbutil [2012/07/12 23:17] – [Repair Process] PUGwiki Adminutilities:dbutil [2018/08/30 00:19] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====== Pedigree Database Utilities ====== +====== Pedigree Database Utility ======
- +
- +
- +
-A Database Utility program is available that has two functions:+
  
 +A Database Utility program is available that has three functions:-
  
   * Database reorganization, to remove the unused space that accumulates in Pedigree Sofware's databases after a lot of data entry and editing.   * Database reorganization, to remove the unused space that accumulates in Pedigree Sofware'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.   * Database repair, when PediTree cannot open a database, or experiences difficulties in Check DB or GEDCOM export.
  
- +The Database Utility is available for {{:utilities:setdbu245.exe|download}} here, as an installer (version 2.4.5860Kb). 
- +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.
-The Database Utility is available for {{:utilities:setdbu230.exe|download}} here, as an installer (version 2.3.0531Kb). +
- +
-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 inf +
-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.
  
 +==== Changes in New Version ====
 +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.
  
-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.+Version 2.4.4 fixed an issue with 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.
  
utilities/dbutil.1342127824.txt.gz · Last modified: 2018/08/30 00:10 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki