March 2, 2011 at 2:09 pm
I'm starting a new genealogy project and need to be able to import and export GEDCOM. I'd like my database to "work well" with GEDCOM data. Do you have any suggestions as to what my database structure should look like? Thanks.
March 10, 2011 at 1:58 pm
I too want to get GEDCOM data into SQL. I get fustrated by genealogical programs inability to do mass data management that I know how to accomplish in SQL Server. I started this project about 8 months ago, writing a stored proc to convert the GEDCOM data that had been exported to CSV and then imported to temp work table. I quit that project and since removed the work. I am starting over today, using SQL 2008 R2 Express, and maybe SSIS package to import / export data.
Have you made any progress? Willing to share?
- Martin Graves
Georgia, USA
March 15, 2011 at 3:05 pm
Hello Martin,
My progress is slow so nothing to share at this point. I'm sure there is something out there we can leverage ... just need to keep looking, or if not, build it ourselves.
August 25, 2012 at 8:52 am
The question is quite old now, but I just see it right now.
I was creating a schema a while ago which you could find in the attachment along with the DDL.
A front end in form of a web page would make perfect sense in order to allow collaboration. Then it would be necessary to add authorisation to edit / view each person. The import /export parser should support GEDCOM 5.5 only as the Gedcom XML (6.0) is nowhere supported. There ares some additions to GEDCOM 5.5 such as 5.5.1 and GEDCOM EL (extended locations).
Unfortunately I did not find the time to continue this project presently.
brgds
Philipp Post
August 25, 2012 at 2:20 pm
Philipp Post,
Excellant looking work. I've downloaded to local machine to see, use as a standard, etc. I'll post next chance I get on this project too.
MDG
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply