任何了解现有Foxpro数据库模型的工具？ [英] Any tools for Understanding Existing Foxpro Database Model?

问题描述

我有一些foxpro数据库的dbf文件。但是，我不知道有关外键的表之间是什么关系，什么表是相互关联的等等。有什么工具可以帮助我轻松学习关系。我的意思是，可以画出关系，而不是通过打击来尝试。
我想将此数据库导出到Microsoft SQL Server。所以我想学习整个数据库模式来学习表逻辑。
谢谢

解决方案

这只是一组VFP免费表还是有VFP数据库？如果有数据库，您将拥有带有DBC，DCT和DCX扩展名的文件。如果你有这些，打开数据库并查看：

 打开数据库任何
修改数据库
  

如果在表之间定义了关系，您将在那里看到他们。

VFP附带一个名为GENDBC的程序，将生成代码以重新创建数据库。因为它是所有的SQL代码，这可能有助于您查看在那里的内容。

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

解决方案

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:

OPEN DATABASE whatever
MODIFY DATABASE

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.

这篇关于任何了解现有Foxpro数据库模型的工具？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！