Lotus Notes 到 Sql Server 的迁移
我正在尝试找到在不使用第三方工具的情况下从 LotusNotes 到 Sql Server 的数据迁移的解决方案。然而，我发现客户已经拥有 LEI 许可证。我可以建议他们使用 LEI 将数据从 Lotus Notes 迁移到 Sql 服务器吗？是否可以？我需要一些关于这个的指示 请注意，这不是预定的数据同步。
I am trying to find the solution for data migration from LotusNotes to Sql Server without using third part tool. However, I have found out that client already has a license for LEI. Can I suggest them to use LEI for migrating data from Lotus Notes to Sql server. Is it possible? I need some pointers on this
Note it is not scheduled data syncronization..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我不确定 LEI (http://www-01.ibm.com/software/lotus/products/enterpriseintegrator/) 是否是正确的选择。它旨在允许 Notes 和某些后端数据库系统之间共享数据。请注意，我对 LEI 没有任何实际经验，因此它很可能有某种方法来帮助您传输数据。我的观点是，据我所知，这不会是我的第一选择，因为迁移数据不是主要目的。我还认为，对于一个可能需要一些手动交互才能将数据放入 RDBMS 系统的项目来说，这似乎有些过大了。
根据您需要迁移的数据，我希望将数据从 Notes 导出到 Excel，然后将其提取到 SQL 中以适合您设计的架构。使这个过程分为两步，您可能会省去一些麻烦。
从基于文档的数据库迁移到关系数据库可能需要对数据进行一些重组。您可能希望在 Notes 中构造类似于 SQL 数据库模式中的表的视图。然后，您可以通过选择所有文档并单击“编辑”>“将视图轻松复制到 Excel”。将所选内容复制为表，然后将结果粘贴到 Excel 中。
另一个不错的选择是使用 NotesSQL 驱动程序 并通过 SQL 管理提取数据工作室。如果您认为在导入之前不需要清理 Excel 中的数据，那么此方法非常有用。
通常，在移动数据时，一个“陷阱”将围绕富文本项。从 Notes 导出富文本非常困难，为此我通常推荐 Geniisoft Midas LSX。我还没有看到任何比该工具更好（甚至接近）的东西。不过，如果您只需要富文本字段中的文本，SQL 驱动程序确实支持从 RT 项目中仅提取文本。
希望这有帮助！
I'm not sure LEI (http://www-01.ibm.com/software/lotus/products/enterpriseintegrator/) is the way to go. It was designed to allow data to be shared between Notes and some back-end database system. Note, I don't have any real experience with LEI so it very well may have some way to help you transfer data. My point is just that it wouldn't be my first choice since migrating data is not the primary purpose, from what I can tell. I also think it seems like overkill for a project that will likely require some manual interaction to fit the data into an RDBMS system.
Depending on the data you need to migrate, I would look to export the data out of Notes into Excel, and then pull it into SQL to fit the schema you've designed. You'll potentially save some headaches making this a two-step process.
Moving from a document-based database to a relational database will likely require some restructuring of your data. You may want to construct views in Notes that resemble the tables in your SQL database schema. You could then easily copy the views to Excel by selecting all the documents and clicking Edit > Copy Selected As Table, and then paste the results into Excel.
Another good option is to use the NotesSQL driver and pull data out via SQL Management Studio. This works great if you don't think there's any need to clean up the data in Excel before importing it.
Usually when moving data the one 'gotcha' will be around rich-text items. It's very difficult to export rich-text from Notes, and I usually recommend the Geniisoft Midas LSX for that. I haven't seen anything better (or even close) to what that tool can do. If you just need the text out of the rich text fields, though, the SQL driver does support extracting text-only from RT items.
Hope this helps!
如果您拥有 LEI 许可证，那么您绝对应该考虑 LEI。正如其他人所指出的，它的设计目的是使数据与 RDBMS 保持同步，但将其用于一次性迁移也非常有效。
您需要花时间学习如何使用该工具，但它免费为您提供了很多东西，如果您手动完成一些操作，则需要编写代码。使用 LEI 还意味着，如果您拥有大量数据，则可以在最终切换之前进行部分迁移。
You should definitely consider LEI if you have a license for it. As others have pointed out, it's designed for keeping data in sync with a RDBMS, but using it for a one shot migration also works great.
You will need to take the time to learn how to use the tool, but it gives you a lot of things for free that you would need to code around if you did something a little more manual. Using LEI also means that if you can be partially migrated before the final cut-over if you have a lot of data.
更常见的是使用 LEI 来使 SQL 数据库与 Notes 数据库中的内容保持同步。这就是我之前使用它的目的。也就是说，LEI 当然可以用于迁移。在迁移之前，您仍然会遇到清理数据的相同问题（例如，具有过时值的选择列表字段）。
相关组织是否有精通 LEI 的人员？如果他们这样做，那么林雷就值得考虑。从头开始学习它所需的时间可能会排除它作为您项目的选择。我知道有针对 LEI 的 IBM 官方文档；我不知道有什么课程。我无法通过谷歌找到任何内容。
上一篇关于导出富文本项目的文章非常值得记住。
It's more usual to use LEI to keep an SQL db up to date with what's in the Notes db. That's what I've used it for previously. That said, LEI could certainly be used for a migration. You'll still have the same issue of cleaning up your data before the migration (eg. pick list fields with obsolete values).
Does the organization in question have someone who is proficient in LEI? If they do, then LEI is worth considering. The time needed to learn it from scratch might rule it out as a choice for your project. I know there is official IBM documentation for LEI; I don't know of any classes. I could not find any via google.
The previous post on exporting rich text items is well worth keeping in mind.
我假设这是单向任务，因为您使用“迁移”而不是同步。
您可以编写一个代理程序将每个文档导出为 DXL (Domino XML)。 DTD 随 Lotus Notes/Domino 安装一起提供。使用 XSLT 重新格式化为首选 XML 格式，然后将其导入 SQL 中。
用于将文档导出为 DXL 的示例 Lotus Script 代理：https://www-304 .ibm.com/support/docview.wss?uid=swg21206902
用于批量导入 XML 文件的 SQL 示例： http://weblogs.sqlteam .com/mladenp/archive/2007/06/18/60235.aspx
I'm assuming this is one way task since you used "migration" instead of sync.
You could write an agent to export each document out as DXL (Domino XML). The DTDs come with your Lotus Notes/Domino install. Use XSLT to reformat to a preferred XML format and then import these into SQL.
Sample Lotus Script agent to export documents as DXL: https://www-304.ibm.com/support/docview.wss?uid=swg21206902
Sample SQL to bulk import XML files: http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx