Hi guys, I need to migrate some data from Lotus Notes to Ms SQL Server. However, I'm not Lotus Notes developer. C an anyone suggest some reading resources that I can learn some basic of Lotus Notes so I know how to export data from it to Ms SQL? Thanks.
Chloe, I'm not a Lotus Notes developer either, but google has some good resources. You could also check IBM's website for more technical documentation. [ May 15, 2005: Message edited by: Jeanne Boyarsky ]
In my pov theres no need to learn a whole proprietary programming platform to do a 1 time export of data. I offer my help. Its not that difficult. If you don't understand me, ask question.
First: You might need a notes designer client for the task. Do you have that? It might be important.
Overview: Most general way for the task is in my opinion to write a so called notes agent. But it may be that its going to be a bit simpler. In that agent you: 1. establish a connection to MS-SQL 2. select which notes-data you are going to export. 3. read data from notes 4. write data to MS-SQL 5. close connection to MS-SQL as allways.
You start with point 2. Data in Notes is stored in units called documents. Those documents are in other elements called views. You must first tell me, if you know the view of the notes app which contain the documents holding the data you are going to export. And if you know the field-names of the data in the documents. I hope you are just going to export simple tables and there are no 1-n relationships of the data to export. If you don't know the view, I can tell you how to find the correct one. Or build new one.
If you have the view you may even create a csv file which you might import into MS-SQL. But only if data structures in Notes are simple (no 1-n rel.). There is also a programatic way writing so called notes agent, which you can write in Java or LotusScript last one similar to visual basic. But I should be able to provide you the necesary syntax and with Java in Notes you have more administrative hassle and no simple debugger.
[ May 15, 2005: Message edited by: Axel Janssen ] [ May 15, 2005: Message edited by: Axel Janssen ]
You don't like waffles? Well, do you like this tiny ad?
Devious Experiments for a Truly Passive Greenhouse!