Tip: Keep Your File in Shape with Database Tools


Database Tools

Occasionally things break.  And when they do, we break out the tools to fix them.  Sometimes we even use tools preemptively to keep things from breaking later.  Databases are no different, and RootsMagic provides database tools to check the integrity of your database, or even fix issues like “phantom children” in your database.  To open the Database Tools, select File > Database tools from the menu.

2014-08-25_15-31-33

The Database Tools screen is very simple, with 4 commands to choose from.

2014-08-25_15-32-36

Each of the 4 commands simply performs the command and then pops up a status message (which may be no more than a simple “OK”).

Test Database Integrity

This command analyzes your RootsMagic file to check if there are any problems with the database structure itself.  These are not problems with data (like a person being born before their father), but are corruption within the data structure itself.  This type of corruption is rare, but it is important to check for it occasionally.

When this command finishes running it will either just display “OK” (which is what you want), or it may display a list of any corruption in the file.  Sometimes this corruption can be fixed by running one of the other database tools (like Rebuild Indexes), but sometimes the only recourse is to restore a backup.

You can run this command when you open your database to make sure there is no corruption before you start entering new information, or you can run it before creating a backup to make sure your database is good to go before backing it up.

Rebuild Indexes

Your RootsMagic file contains two things… data and indexes.  The data is what you actually type in (names, dates, places, notes, etc), while the indexes are what the RootsMagic database engine creates so that it can search for and find that data faster.  This command rebuilds those indexes.  Like any of the database tools, you can run this command anytime without worry, but it can be most useful if the Test Integrity check comes up with index errors.

Clean Phantom Records

This is probably the most useful of the database tools, or at least the one that you can see its effects.  Occasionally your database can pick up what we call “phantom records”.  These are unwanted pieces of information (sometimes blank) that appear in your database, but you are unable to remove them using the normal RootsMagic features.

For example, you may find a family with a “phantom child”… a blank row in the child list on the family view which you can’t unlink or delete using the regular Edit > Unlink or Edit > Delete commands.

This command will search your file for all kinds of phantom records and will remove them for you.  Again, it doesn’t hurt to run this feature even if you haven’t run across any phantom records yet.

Compact Database

When you delete a person or other item in RootsMagic, the program simply marks the record as deleted, but doesn’t free up the space the record was using.  Normally this isn’t a real problem, but if you are deleting a lot of records in RootsMagic, this command will reclaim that space and reduce the size of your RootsMagic file.

Database Tools in Action

Here is a short video we created showing the database tools in action.

Information and Links

Join the fray by commenting, tracking what others have to say, or linking to it from your blog.


Other Posts

Reader Comments

Thank you so much! I have many phantom records and have many times tried to get rid of them. This is great!

Thanks for the reminder! It has been so long since I ran these that I had forgotten about them. Didn’t come up with problems, through sheer luck, not care or skill. But I like the ‘proactive’ part. Won’t forget again.

I have a question. When you
Compact your Database, do the RINs change? or is the lowest unused number assigned to the next new entry?
All the tools are great. I use them regularly. Thanks

Larry, the RINs do not change when you compact your database.

Although I’m a fairly new user, I had already created a phantom child. Thanks for the timely help!

Once again, thanks for your advices!
Like others, I had forgotten how useful this tool was – good to be reminded.

Just a reminder, this feature is only available in the full version of RootsMagic, versus the free version.

I enjoy all the Tips and reminders.

Bruce;
I am running Rootsmagic #4.
When clicking on file, database tools does not show up. Is that feature for other issues?
If so, should there be separate instructions for RM #4?
Thank you for your comments.

John R. Heintz.

Reply: The Database Tools were added in RootsMagic 5. It is only available in the full version of the program. If you have RootsMagic 4 and feel you have some database corruption the only option is to either GEDCOM or drag n drop your database into a new blank database.
Renee, RootsMagic

Thank you. I had seen this before but had forgotten about it. I am going to use it as I have several problems it might clear up.I appreciate having it written out and then shown step by step. I learn better when I see what you are doing.

Rebuild Indexes also updates the Birth Year values shown, optionally, in the Sidebar Index and the Death Year values, both of which are used in other displays, reports or charts. These values are derived from the dates of primary Birth event or primary Christen event (in the absence of a Birth event), primary Death event or primary Burial event (in the absence of a Death event). These year values are stored in a database table with the person record for speedier access than would be the case if the event table had to be searched and processed every time. Under some procedures, these fast year values and the event dates get out of sync. Rebuild Indexes brings the fast year values back in sync.