Users generally don't take that news well when you show them the price tag associated with it. DeliverySlip can be used within G Suite, Office 365, and Outlook, allowing users to send messages, forms, and files, and request approvals and electronic signatures from within their inbox without needing to change the tools they use. This is the joy of system migrations, that is, to go from one technology to another and still give users the same system. So allow for it.Ħ/ You should now be able to identify all the known gaps in the data and make adjustments to tweak the data or change your final design.ħ/Design your final loading scripts to move the data from Triage to the production quality relational system. These tables usually don't have much in the way of constraints or rules, because Lotus Notes data will generally not conform to it. This will help you find gaps between Lotus Notes data and functionality with the new system.Ĥ/ Design exports of documents from Lotus Notes into flat files or you can load them straight into the tables in the next step.ĥ/ Load the raw data into a set of "triage" tables for data cleansing as you'll find some fields may be null or empty. ![]() Here is a high level approach to migrating data.ġ/ Analyse the views and identify the sorted order as an indication of keys.Ģ/Look at the forms to see how many fields you need to export.ģ/ Draw up your new design for data and the UI. The real work will start when you see the size of the relational design and UI technology to mimic what Lotus Notes does natively. Depending on the complexity, this may not be a huge task. In many cases you will need to create your own specific unique keys. You then need to consider the complexity of the UI in the form design and how you will replicate that. You can start by looking at the sorted order of the views, and the view formulas they are using. Lotus Notes is like " NoSQL"Īs Domino is un-structured, you need to manually check the views that will give you an indication of the relationships between documents and what referential integrity constraints you need to apply. ![]() There are no tools that can auto-magically translate a non-relational unstructured LN DB into an SQL schema.
0 Comments
Leave a Reply. |