Migrating data to SQL SERVER 7.0

[Guest_imported]

Hi,
I am new to lotus notes. I have a requirement to tranfer data stored in lotus notes to sql server.
Can somebody give me information on how I can do this...
All help is appreciated.
Thanks in advance
Gp

 

[PghMikeH]

First, you're going to need to build views to export all of your data. Best practice calls for putting the field name as the column heading. If you're using any rich text fields, I'm not much help there.

After you have all of these views, you can either set up NotesSQL to use the Domino server as a data source, or you can just export the data to a spreadsheet/text file. After that, use your SQL server tools to suck it in.

Mike Hillwig
mike@hypermike.com

http://www.hypermike.com

I've done more R5 deployments than I care to think about.