将 Outlook 电子邮件存储在 Microsoft SQL Server 数据库中
我正在使用 C# 编写 Outlook 2007 加载项以将电子邮件存储在 SQL Server 2005 数据库中。我希望能够将整个 .msg 文件存储在 varbinary(MAX) 字段中。有没有办法做到这一点，而不必使用 Outlook MailItem 的 SaveAs() 方法保存到临时文件，然后读回该文件？我需要将大量电子邮件传输到数据库，并且希望避免昂贵的磁盘读取和写入。
I am using c# to write an Outlook 2007 add-in to store emails in a SQL Server 2005 database. I would like to be able to store the entire .msg file in a varbinary(MAX) field. Is there a way to do this without having to use the Outlook MailItem's SaveAs() method to save to a temp file and then read the file back in? I will need to transfer a large number of emails to the database and would prefer to avoid costly disk reads and writes.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您希望将其实际存储为 .msg 格式文件，而不尝试自己重写，我想说您正在考虑采用您提到的路线。
就我个人而言，我会去存储电子邮件的一些片段，但这取决于您要如何处理它。在我看来，将 MSG 文件存储在数据库中实际上并没有什么价值。现在你的用例可能证明情况并非如此。
If you are looking to actually store it as a .msg format file, without trying to re-write this yourself, I would say that you are looking at going the route you mentioned.
Personally I would go to storing bits and pieces of the email, but that depends on exactly what you are going to do with it. Storing a MSG file in an DB in my opinion isn't really anything of value. now your use case might prove otherwise.
可能吧。
根据您的设置，您可以避免使用 Outlook，而仅使用 Exchange/SQL Server。
将服务器链接到 Exchange。
我从来没有试过了 YMMV
Possibly.
Depending on your setup, you can avoid Outlook and just use Exchange/SQL Server.
Linked server to Exchange.
I've never tried it so YMMV