Transfer Lotus Notes to SQL Database

Asked By gary fisher 0 points N/A Posted on - 11/15/2011

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.

• Status: Open
• Question Views: 973
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Zorian Crust 80 points N/A #110806

Transfer Lotus Notes to SQL Database

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

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 11/17/2011
• Question Category: MS SQL Server