存储在 SQL 表中的文档
我有一个遗留的 FoxPro 应用程序，它将文档存储在 SQL 表中具有图像数据类型的字段中。 FoxPro 将图像数据类型作为“常规”字段访问，可用于存储各种文件。我有一个 FoxPro 控件，它与常规字段交互，用于修改/查看存储的文档。我需要将此控件迁移到.NET，以便用户轻松查看/修改各种类型的文档。
有没有人对解决此问题的一些方法有任何建议，或者知道我在迁移到 .NET 时需要考虑的事情？我非常确定我需要将该字段迁移到 varbinary(max) 或 FileStream 数据类型。
I have a legacy FoxPro application which stores documents in an SQL table in a field with the image datatype. FoxPro accesses the image datatype as a "General" field which can be used to store various files. I have a FoxPro control which interfaces with the General field for modifying/viewing the document that was stored. I need to migrate this control to .NET and make it easy for users to view/modify documents of various types.
Does anyone have any suggestions on some ways to go about this or know of things that I'll need to consider for the migration to .NET? I'm pretty sure that I'll need to migrate the field to either a varbinary(max) or FileStream data type.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您确定要继续将文档保留在数据库中吗？对 Foxpro 有利的东西并不总是对 .Net 有利。
您可能必须使用 Foxpro 来读取常规字段，然后上传它们或将它们保存在本地以供其他应用程序上传。
看看我可以从foxpro中提取文件吗常规字段？ 有关常规字段的详细信息和 http://blogs.msdn.com/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx 用于文件流与 varbinary 比较
Are you sure you want to continue holding the documents in the database? What's good for Foxpro isn't always good for .Net
You're probably going to have to use Foxpro to read the general fields, and either upload them or save them locally for another app to upload.
Have a look at Can I extract a file from a foxpro general field? for good info on general fields and http://blogs.msdn.com/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx for a filestream vs varbinary comparison