August 27, 2002 at 8:43 am
We are in the first stages of converting a Lotus Notes 'database' into SQL Server 2000. Wondered if anyone else had attempted this with or wothout a 3rd party tool and if anyone had any ideas,hints, suggestions....
Thanks!
August 27, 2002 at 9:47 am
No experience here. However we do use both SQL Server en Lotus Notes in our company.
I would use the ODBC driver for Lotus Notes. This gives you relatively easy access to the Notes DB that is comparable to a 'real' relation DB.
In fact, all documents of the same type (form) are presented in one table. Of course, you will have to enforce any referential integrity yourself.
And knowing only a bit of the way Lotus Notes works, you'll probably will have to throw away heaps of data, to get your SQL DB normalized to a certain extent.
September 11, 2002 at 12:45 am
I used NotesSQL as a driver just for the Data migration. Never had to migrate the code on documents. I believe I downloaded the NotesSQL file off the Notes site.
September 11, 2002 at 3:38 am
Another group here used NotesSQL and I don't remember them having too many issues getting connected.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply