What is the best way to migrate from Domino (app and data store) to Java and Oracle?
Migrating from a Domino application to an application written in Java that uses an Oracle back-end is a huge undertaking. I've done application designs like this, and the process was always bigger than I anticipated. One of my clients recently migrated from Sybase to Oracle, leaving the Domino application as is. The process took several months.
Here's a brief list of steps for you to take. These should give you an application architecture and migration plan:
Application Review: An overview of the applications goals, requirements, users, support capabilities, etc.
Business Logic Analysis: Document all processes and workflows (i.e. existing forms, views, agents, etc.) to create an application map.
Data Modeling: Produce a database schema from the current Document-based structure of the NSF.
Architectural Modeling: Determine if the application will support J2SE, J2ME and or J2EE.
Infrastructure Analysis: Determine what application server you will be using, as this may determine/provide other components you need (such as the EJB Container for a J2EE application).
I advise you to get experienced help with your plan. If you don't have access to an in-house expert, hire a good consultant -- or you'll pay for it later. Good luck!
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Notes Domino Deployment and Migration Advice