Migrating Lotus Notes data to SQL
Summary
By looking at the various views and folders, we can learn a lot about the business use cases and what the application was used for, and can then make further plans for migrating the database to SQL. Another important aspect of the Notes database that needs to be considered is the Access Control List, or ACL for short. This should be fairly straightforward: • Open the Notes client, select a view, choose File > Export, save as a Comma Separated Value (CSV), and you’re good to go! In such cases especially, creating a new SQL database and writing migration scripts might seem like an overkill if the end goal is simply to keep the file in cold-storage for possible future reference or e-discovery. In so many situations, this really helps organizations to speed up their migration efforts, typically unlocking their acute analysis paralysis.