Search the Community
Showing results for tags 'database sql schema'.
Found 1 result
Direct database access
rowan.bradley posted a topic in The Master Genealogist v8Is there a way of accessing the TMG database directly? Obviously to do this I would need to thoroughly understand the schema of the database - is this documented somewhere? The reason I'm asking is that I' ve discovered a rather interesting web based way of displaying genealogy data, and the guy who wrote this has given me a copy of his code. I would like to try it with my genealogy data, but it's in TMG. For this tool it needs to be in some tables in MySQL, and the design of the tables will of course be different from those of TMG, so I need to produce a translation tool, or an export and import tool. I know I could export all the data into GEDCOM and then write a GEDCOM import tool for the display system, but (a) going from a relational database to an idiosynchratic text based format and then back to a relational database seems like hard work, and ( I don't want to lose any data that might be in TMG but is not in the GEDCOM export file. Thanks - Rowan