可视化数据库并快速了解数据模型的工具 [英] Tools to visualize a database and understand the datamodel quickly

问题描述

我有几个SQL Server 2005数据库，范围从20 - 600表在一个应用程序，没有文档。我正在寻找一个数据库图表工具，它足够聪明地选择似乎与一个实体相关的表（例如，与患者相关的表，与订单相关的表）或一个功能（例如，患者管理，订单管理）它们单独而不是绘制整个数据库。

I have several SQL Server 2005 databases ranging from 20 – 600 tables in an application and no documentation. I am looking for a database diagramming tool that is smart enough to pick tables that seem to be related to one entity (e.g., tables related to Patient, tables related to Orders) or one functionality (e.g., Patient Management, Order Management) and show them separately instead of drawing the entire database.

过去，我已经看到了与ER图中的一种颜色表示的一个功能相关的表格。在设计良好的数据库中，可能有多个模式将与一个功能相关的表组合在一起。但是由于所有这些表都在一个模式中，我想要一个聪明的工具，可能建议在一个模式下哪些表应该在一起。它不会是完美的，但也许是智能的，足以检查哪些表应该在一起（例如基于它们之间的关系或基于哪些表似乎在存储过程中一起访问）。

In the past, I have seen tables related to one piece of functionality represented in one color in the ER diagrams. In a well designed database, perhaps there will be multiple schemas that group tables related to one functionality together. But as all these tables are in one schema, and I want a tool that is smart enough to perhaps suggest which tables should go together under one schema. It won’t be perfect but perhaps it is intelligent enough to examine which tables should go together (for example based on relationships between them or based on which tables seem to be accessed together in the stored procs).

底线是我想要尽可能快地理解数据模型。名为Schema Spy的工具（ http://schemaspy.sourceforge.net/ ）似乎在正确的方向，但我想知道是否有人知道更好/更全面的工具。

The bottom line is that I want to understand the data-model as quickly as possible. A tool called Schema Spy ( http://schemaspy.sourceforge.net/ ) seem to be headed in the right direction, but I was wondering if anyone knew better/more comprehensive tools.

谢谢。

推荐答案

我推荐 Vertabelo 。它是一个在Chrome和Safari下工作的在线数据库设计人员。

I recommend Vertabelo. It’s an online database designer working under Chrome and Safari developed by company I work for. It is free to use for academic projects and have commercial version for larger.

Vertabelo是：

Vertabelo is:

• 操作系统独立


• 列表项


• 允许版本控制


• （包括MS SQL Server）


• 允许与您团队的其他成员共享数据库模型


• 允许逆向工程 - 模型到Vertabelo

• OS independent
• List item
• allows versioning
• generates SQL scripts for particular databases (MS SQL Server included)
• allows sharing your DB model with other members of your team
• allows reverse engineering – so you can easily migrate your DB model to Vertabelo

这篇关于可视化数据库并快速了解数据模型的工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！