有什么工具可以理解现有的 Foxpro 数据库模型?
我有一些foxpro数据库的dbf文件。但是,我不知道表之间的外键关系是什么,哪些表是相互关联的等等。有没有什么工具可以帮助我轻松学习人际关系。我的意思是,这可以建立关系,而不是我通过尝试来弄清楚。? 我想将此数据库导出到 Microsoft SQL Server。所以我想学习整个数据库模式来学习表逻辑。 谢谢
I have some dbf files of foxpro database. However, I have no idea about what are relationship between tables regarding foreign key, what tables are inter related and so on. Is there any tool which can help me to learn relationships easily. I mean which can draw relationship instead of me figuring out by hit and try.?
I want to export this database to Microsoft SQL Server. So I want to learn whole database schema to learn tables logic.
Thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
这只是一组 VFP 可用表还是还有一个 VFP 数据库?如果有数据库,您将拥有带有 DBC、DCT 和 DCX 扩展名的文件。如果有这些,请打开数据库并查看:
如果表之间定义了关系,您将在那里看到它们。
VFP 附带一个名为 GENDBC 的程序,该程序将生成重新创建数据库的代码。由于都是 SQL 代码,因此这也可以帮助您了解其中的内容。
Is this just a set of VFP free tables or is there a VFP database, as well? If there's a database, you'll have files with DBC, DCT and DCX extensions. If you have those, open the database and take a look:
If there are relationships defined between the tables, you'll see them there.
VFP ships with a program called GENDBC that will generate code to recreate a database. Since it's all SQL code, that might help you to see what's in there, as well.
Stonefield 数据库工具包 设计用于与 Visual FoxPro 配合使用,并具有大量文档功能。虽然不是免费的。
The Stonefield Database Toolkit is designed to work with Visual FoxPro and has a lot of documenting ability. Not free though.