Exploit your RootsMagic family tree database with SQLite Tools
The database documentation was done largely on RootsMagic version 4.0.7.1. As far as we can tell, the database schema has not changed, as of version 4.1.2.1. Changes may be detected by opening a database created by each version with a SQLite manager; then exporting either a query of the full sqlite_master table or the database…
The following non-system tables currently reside in the RM5 database: Name Description AddressLinkTable Translates OwnerID from various tables to the key AddressID in AddressTable. AddressTable Stores Addresses for Persons in the tree, Repositories, and other entities that need not be in the tree. Note that the Name in this table is not the same as…
A singular system table, sqlite_master, resides in a SQLite database. The table in the RootsMagic 5 database essentially defines the RootsMagic 5 database tables, indices, and fields, as below. Differences in structure with RootsMagic 4 include the addition of a new table, ResearchItemTable (and its index), to incorporate the newly-incorporated Research Log feature. In addition,…
I followed your instructions and was able to link to my MSAccess database – but all the files are read-only. Any tips on what might be causing that behavior, rather than them being read/write as your instructions note? Do you have details on the way the indices join between the tables? Do you have an…
RootsMagic 4 Database System Catalog A singular system table, sqlite_master, resides in a SQLite database. The table essentially defines the RootsMagic 4 database tables, indices, and fields as follows: type name tbl_name rootpage sql table AddressLinkTable AddressLinkTable 52 CREATE TABLE AddressLinkTable (LinkID INTEGER PRIMARY KEY, OwnerType INTEGER, AddressID INTEGER, OwnerID INTEGER, AddressNum INTEGER, Details TEXT…
Gedcom 5.5 Gedcom 5.5 Gedcom 5.5 in Windows Help (chm) format
RootsMagic 4 File Types Ext Description More rmgc family tree database SQLite 3-format file readable with SQLiteManagers rmgb family tree database backup ZIP-format file extractable not only within RM, but also by PKZip, WinRAR, et al. st Source Template master file used to create sourcetemplatetable on creation of family tree database Source Templates adl…