Transfer Lotus Notes to SQL Database

Asked By 0 points N/A Posted on -
qa-featured

How can you transfer or move a Lotus Notes to the database of SQL? My company is in need of help on how to properly change the Lotus Notes Databases to SQL Databases that has the same views and functions. How can I do this right? Thanks.

SHARE
Answered By 80 points N/A #110806

Transfer Lotus Notes to SQL Database

qa-featured

Hello Gary,

 

Below are the step by step process on how to transfer lotus notes from sql database:

  • Just design the table structure primary key, join relationship
  • Make the export view for each table, match all the columns, rows, field format.
  • Export each export views to either text or lotus 123 format
  • Import the data from either text or wks file to SQL.

Rebuilding  the views is not an issue as that`s what SQL good for. Just do simple query will do however, the categorized feature is something you need to refine it in your reporting tools.

I hope it helps. Please let me know what happened after trying my solution. I'll be happy to hear from you. Have a great day!

Zorian

Related Questions