Convert Lotus notes (.nsf) to SQL
This application finds Lotus Notes applications on a Domino server or local computer and exports the documents to a SQL file or directly to a MySQL server.
The tables are forms with each document as a row.
It stored fields with multiple values as separate tables linked with a foreign key.
1. Click [Download as .zip] above.
2. Unzip the file and go to \NSF2SQL\bin\Debug.
3. Open NSF2SQL.exe.
4. Click [Search Server] to search for an application on a Domino Server or [Search Computer] to browse your computer for a .nsf file.
5. Enter the server information if searching a server or just the password if opening a local file.
6. Select the database to export and click [Export Documents].
7. Wait until the program is done parsing the documents.
8.Once all documents are parsed it will ask if you want to export to a server. Click [Yes] to have the sql imported directly to a MySQL server or click [No] to have the SQL dumped to a file so you can import it a different way.
9. If you chose to have the program import it directly to a MySQL server it will ask for your server information. Database is the name you want for the new database
10. If you chose to dump the SQL to a file it will be saved to a file called "export.sql" on your desktop and it will be opened after the program creates it.