从Lotus DB到SQL Server的迁移 [英] Lotus DB to SQL Server migration

问题描述

我的公司在IBM的Lotus DB中有一个数据库.它的设计早就回来了.现在，合同即将结束，我们需要将其转移到SQL Server.问题在于这是一个庞大的组织，并且由于这些数据库非常老...我们无法追踪设计它的人.现在，我们只有使用Lotus DB构建的应用程序.有什么方法可以将其迁移到SQL Server?有什么好的工具可用于将数据迁移到SQL Server?

My company has a database in IBM's Lotus DB. It was designed long back. Now, the contract is ending, and we need to transfer it to SQL Server. The problem is that it is a huge organization, and since these databases are very old...we are not able to track the person who designed it. Right now, we just have the application which was build using the lotus DB. Is there a way we can migrate this to SQL Server? Are there any good tools available to migrate the data to SQL Server?

推荐答案

没有工具可以自动将非关系非结构化LN DB转换为SQL模式. Lotus Notes就像" NoSQL "

There are no tools that can auto-magically translate a non-relational unstructured LN DB into an SQL schema. Lotus Notes is like "NoSQL"

由于Domino是非结构化的，因此您需要手动检查视图，以指示文档之间的关系以及需要应用哪些参照完整性约束.您可以先查看视图的排序顺序以及它们使用的视图公式.然后，您需要考虑表单设计中UI的复杂性以及如何复制它.

As 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. You can start by looking at the sorted order of the views, and the view formulas they are using. You then need to consider the complexity of the UI in the form design and how you will replicate that.

在许多情况下，您将需要创建自己的特定唯一键.根据复杂程度，这可能不是一项艰巨的任务.当您看到关系设计和UI技术的规模来模仿Lotus Notes本身的功能时，便会开始真正的工作.

In many cases you will need to create your own specific unique keys. Depending on the complexity, this may not be a huge task. The real work will start when you see the size of the relational design and UI technology to mimic what Lotus Notes does natively.

这是一种用于迁移数据的高级方法.

1/分析视图并确定排序顺序以指示键.

1/ Analyse the views and identify the sorted order as an indication of keys.

2/查看表格以查看您需要导出多少个字段.

2/Look at the forms to see how many fields you need to export.

3/为数据和UI绘制新设计.这将帮助您发现新系统在Lotus Notes数据和功能之间的差距.

3/ Draw up your new design for data and the UI. This will help you find gaps between Lotus Notes data and functionality with the new system.

4/设计将文档从Lotus Notes导出到平面文件中，或者在下一步中将其直接加载到表中.

4/ Design exports of documents from Lotus Notes into flat files or you can load them straight into the tables in the next step.

5/将原始数据加载到一组分类"表中以进行数据清理，因为您会发现某些字段可能为null或为空.这些表通常没有太多的约束或规则，因为Lotus Notes数据通常与之不符.因此，允许它.

5/ Load the raw data into a set of "triage" tables for data cleansing as you'll find some fields may be null or empty. These tables usually don't have much in the way of constraints or rules, because Lotus Notes data will generally not conform to it. So allow for it.

6/现在，您应该能够识别出数据中所有已知的缺口，并进行调整以调整数据或更改最终设计.

6/ 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.

7/设计最终的加载脚本，以将数据从分类"移至生产质量关系系统.

7/Design your final loading scripts to move the data from Triage to the production quality relational system.

这是系统迁移的乐趣，也就是说，从一种技术过渡到另一种技术并仍然为用户提供相同的系统.当您向他们显示与之相关的价格标签时，用户通常不会很好地接受该消息.

This is the joy of system migrations, that is, to go from one technology to another and still give users the same system. Users generally don't take that news well when you show them the price tag associated with it....

这篇关于从Lotus DB到SQL Server的迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！