从 Visual Fox Pro 导入数据
我正在尝试将数据从 FoxPro 数据库导入到 Sql Server，但是数据出现一些非常奇怪的问题。我正在使用 OLE DB 驱动程序并且可以查询数据，但是某些字段似乎包含不同编码的文本。我使用了一些 DBF 查看器工具，它们在那里看起来是一样的。文本示例如下：
SDRSDFFGGDFHEJKIYerwwvFH
这是 FoxPro (v8) 应用的某种编码吗？我怎样才能提取这些数据？
编辑
查看了大多数表格后，确实出现这种情况仅发生在 1 个表格中，并且数据在系统内正确显示，这让我认为它已加密。 FoxPro 中是否有标准加密方法可供我用来解密？
免责声明
提取此数据的目的是帮助从 Fox Pro 应用程序迁移到新的闪亮的非 FoxPro 系统。我得到了以前的系统所有者和数据所有者的全力支持，但没有得到现任开发公司的全力支持，因此出现了这个问题
I am trying to import data from a FoxPro database into Sql Server however am having some very strange issues with the data. I am using the OLE DB driver and can query the data however some of the fields seem to contain text in a different encoding. I have used a few DBF viewer tools and it appears the same in there. An example of the text is:
SDRSDFFGGDFHEJKIYerwwvFH
Is this some kind of encoding that FoxPro (v8) applies? How can I extract this data?
EDIT
Having looked through most of the tables it does appear that this only occurs in 1 table and the data is displayed correctly within the system which is making me think it is encrypted. Are there standard encryption methods used within FoxPro that I can use to decrypt this?
DISCLAIMER
The aim of extracting this data is to assist in migrating from a Fox Pro application to a new shiny non FoxPro system. I have the full support of the previous systems owner and the data owner however not the encumbent development company hence the question
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Foxpro 确实有一些第三方实用程序来进行加密，或者也可以使用自己的框架库实用程序类来执行加密/解密，但它并不像 SHA 等复杂。另一种常见的实用程序是名为“Cryptor”的产品。但是，如果您用它来加密文件以进行保护，我认为您甚至无法打开该文件，因为它还加密了文件头，并且不会被识别为常规表以查看记录。即使它是直接来自 VFP 内部的。
如果您有权访问所有旧代码，甚至可执行文件，您可以对其运行反编译器，以磨练相关表，并在显示字段之前查看是否存在任何代码内加密/解密。这种工作出色的解密工具称为“ReFox”，它将一直解密到表单、类库和prg文件。
Foxpro does have some 3rd party utilities to do encryption, or could also use its own framework library utility class that performs encryption / decryption, but its nothing complex like SHA or such. Another utility that was commonly available was a product called "Cryptor". However, if you encrypted a file for protection with that, I dont think you couldn even open the file as it also encrypted the file header and would not be recognized as a regular table to even view the records. Even if it WAS directly from within VFP.
If you have access to all the old code, or even the executable, you could run a de-compiler against it to hone-in on the table in question and see if there's any in-code encryption / decryption before the fields are displayed. Such decryption tool that does a great job is called "ReFox" and will decrypt all the way down to form, class libraries and prg files.