Basic Diagram of Rootsmagic 9 Tables
I created a basic page with an erd diagram of the Rootsmagic tables. Since there are no foreign keys on the tables I have no connections but I'm thinking I could get alot of those from Tom's diagram (at least for the old tables). I just thought folks might find it interesting: https://familytreehelper.us/Rootsmagic/index.html
Matthew
Yeah I used one that has a 30 day trial. It would cost about 300.00/year to actually buy: https://www.toadworld.com/products/toad-data-modeler
I guess the RM folks must manage their data in the program code instead of using foreign keys to enforce integrity. If there were foreign keys this software would automatically link them. I'll see if I can work on trying to put some of the links in between the tables before the trial expires....
Matthew
Oh, it exports the reports in html, as well as pdf, image, etc.
I had another look and am trying out the free DBeaver. Since I'm a dabbling amateur ( a 'dabbleur'?), I'm not sure what I'm doing. Here's a snippet showing a little progress around the lineage and events. I realise that the diagram is interactive - you don't get what fields are related without clicking on the connection - so a single screenshot doesn't tell all we need to know. And it could get very messy trying to show all the conditional connections.
Uploaded files:
I use Visio on my work pc and was planning to reverse engineer RM9 this week as I did with RM8 https://sqlitetoolsforrootsmagic.com/understanding-the-roots-magic-8-database-database-diagram/
That would be great Pat. I have a lot of papers and work due by/on March 16th, but then I would like to take your revised diagram and use it for the version I had started on. (I'm must trying to understand the structure better). Thank you for your work.
Matthew
Quote from Pat Jones on 2023-03-05, 3:15 amI use Visio on my work pc and was planning to reverse engineer RM9 this week as I did with RM8 https://sqlitetoolsforrootsmagic.com/understanding-the-roots-magic-8-database-database-diagram/
That would be great, Pat! If it's of any use, here's the .graphml output from my efforts with DBeaver and a view of the painstaking progress I've made with manual layout. I think the ERD has almost all of the relationships but for a couple such as FamilySearch which I've never really looked into. However, I cannot find a way to label connections in it so I looked for an ERD editor and landed on yEd Live which imports and exports .graphml, supports labels and has awesome auto-arranging (Tree algorithm arrangement shown). Unfortunately, it loses the datatypes, if they were included in the export from DBeaver.
Uploaded files:
Quote from Tom Holden on 2023-03-05, 5:37 pm
Unfortunately, it (yEd) loses the datatypes, if they were included in the export from DBeaver.
DBeaver can include datatypes in the export if its View Style is set to show them and yEd does import and show them as in this sample. If you want, I can post or email the .erd or .graphml with datatypes.
Uploaded files:
I've posted my Visio of the RM9 database in the main site articles.