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 using the Lists Menu.
Look in the bottom right corner for the location of any image. The full file path is given, so you will also see the folder.
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.