N/APosted 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.
Transfer Lotus Notes to SQL Database
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!