Dec 1st, 2011, 09:09 AM
Has anyone migrated from Lotus Notes / Domino to a relational database using roo
DBRE looks like it might not help to migrate a Notes / Domino database to a roo project. It only seems to apply to relational databases.
Domino is perhaps one of the original NoSQL Databases : It stores Data as Documents, with metadata. Even documents of the same form type could contain different fields (due to sub forms or the design of the form that was in place at the time each document was last saved)
Failing that, it seems that the best option might be to create a batch file ( similar to the log file that get built during the pizza shop tutorial) & build each table & their relationships based on the document heirarchy in the notes database.
I had thought about putting a Domino XML export of the database design through a style sheet to build the batch file, but I can see a few issues with that.
I am now thinking that I should perform a detailed analysis of every document in the database & use that to build up a comprehensive field list of each document type. Any advice on dealing with multi value fields would be gratefully accepted. I am thinking that each multivalue field would need to be used as the configuration for a new child table, perhaps keyed on the parents doc id....
Thanks in advance
Tags for this Thread