How to migrate a (huge) Lotus Notes database to a java application container?

Hi,

How to migrate a (huge) Lotus Notes database to a java application container ?

Description of the business case :

To start a fresh Java application, we need to transfer the content of a huge (400.000 docs - 40 GB) database into a java application container.

the container is a blob in a MySql database, accessed via the Hibernate persistence layer …

What is the best technology to use to achieve this goal ?

? pull the data directly from the Java environment, using notes.jar, or other tools

? use .xml

? push the data from the Lotus Notes environment via Java or LotusScript agent

? use web services

? other solution

Remarks:

  1. The documents in the Lotus Notes db are structurated :

each document can be directly reached via fields “ID number” or “ID name”

  1. The Lotus Notes database use versioning: it can complicate the process !

  2. Ideally, the solution should be reuseable, in case of migration split in different steps…

Please don’t hesitate to send me any potentially useful information, especially if you had to solve such a business case …

Regards,

P Pierlot

Lotus Notes Administrator and Designer,

Belgium