If you need to export a Lotus Notes database into relational format, you might want to give the open source product NotesDB-2.7 a try:
Export a complete Lotus Notes database including all text fields into an SQL databases. The CREATE TABLE statements get generated automatically, based on the actual size of the fields inside the documents. All attachments are automatically exported to the local filesystem. A separate table provides information on all the attachments contained in each document.
Details can be found at the NotesDB Open Source page:
http://www.easymda.org/notesdb/
A commercial version of the product also allows to export Richtext data into HTML, PDF, MS Word or RTF format without any programming.
How easy is it to use it?
Here is a snippet from the docs:
Here are the steps you need to take to export a Notes database into the relational world:
1.) Set up the relational database
2.) Install the ODBC driver for the relational database
(Sidenote: NotesDB supports all LSX datasources, so you can use a native LSX connect as well.)
3.) Create a ODBC datasource for accessing the database and test it.
4.) Choose “Create database” in the database view.
-
Pick the server and database
-
Enter the configuration data of the ODBC datasource
-
Enter the path for exporting the attachments
5.) Pick the buttons for starting the export procedure:
-
Scan database structure will read the structure of the database.
-
Create DDL will generate and execute DDL SQL code to export the data
-
Export data will write the data into the database and export the attachments into the file system.
-
(commercial version only) Get Richtext will stream all data into HTML files and convert them into PDF automatically.
best regards,
Johannes