Differences

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

--- faq:dbutil [2010/10/15 18:46] – created Colin Liebenrood
+++ faq:dbutil [2011/04/23 18:29] (current) – removed Colin Liebenrood
@@ Line 1: / Line 1: @@
-====== Pedigree Database Utilities ======
-A Database Utility program is available that has two functions:-
-  * Database reorganization, to remove the unused space that accumulates in Pedigree Sofware's databases after a lot of data entry and editing.
-  * Database repair, when PediTree cannot open a database, or experiences difficulties in Check DB or GEDCOM export.
-The Database Utility is available for [[http://www.pedigreeug.org.uk/progs/SetupDBU221.exe|download]] here, as an installer (version 2.2.1, 528Kb).
-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.
-==== Reorganization ====
-To reorganize a database, proceed as follows:-
-  - Close PediTree.
-  - Make a back-up copy of the database.
-  - Use the Database Utility to check and reorganize the database.
-  - Open the database in PediTree.
-  - Run **File > CheckDB** to check that all is well.
-  - Close PediTree.
-  - Re-run the Database Utility and remove the pre-reorganize version of the database that it retains.
-==== Repair Process ====
-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.
-  - 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's request to fix any indexes.
-  - In Update mode, run **File > CheckDB** to report and correct any errors.
-  - 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.)
-    - 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:-
-    - Use **File > Save As GEDCOM > GEDCOM 4 Pedigree** to export the whole database. Say 'Yes' to preserving RINs, so that you can easily identify links in the deleted record(s) to ease replacement later.
-    - 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.
-    - 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.
-==== 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.