Step 1: Install RootsMagic and download your Ancestry tree
The free version (RootsMagic Essentials) will complete this task.
There is a step-by-step pictorial guide in this article on using RootsMagic to back up your Ancestry tree.
Alternatively, this video is a step-by-step walkthrough:
Step 2: Copy the RootsMagic media folder
You will rename the media files in a copy of the RootsMagic folder. We don’t change the original folder or the RootsMagic database.
The RootsMagic media folder is in the same directory as the RootsMagic database. The folder has the same name as the database with “_media” appended to the name.
You can also find the location by opening the Media Gallery and selecting any image. The location is shown under the “Edit Media” sidebar on the right.
The full file path is given in the “Filename” details, so you will also see the folder. I’ve highlighted the portion in the image below from my own computer.
Step 3: Install the SQLite Browser on your local machine
You can download the installer from here.
Step 4: Download a copy of our SQL Script
The DataMiningDNA script is a modified version of Tom Holden’s scripts attached to his article here. The original scripts are designed to rename the files in the RootsMagic media folder and update the RootsMagic database accordingly.
Our script does not update the database, which is why we ask you to run the output in a copy of the media folder.
Step 5: Use the SQLite Browser to run our SQL Script
This video shows you how to download the SQLite Browser application.
The video is using an older version of RootsMagic where the database has a .rgmc extension. With version 9, the database has a .rmtree extension. That’s the file that you open with SQLite.