如何生成一个非常大的数据库模式图（SQL Server） [英] How to generate a diagram of a very large database schema (SQL Server)

问题描述

我有一个非常大的数据库我需要图。数据库是x64上的SQL Server 2008。它有很多有关的表，每个有多达2000个字段（一些是稀疏的），表之间的多个关系（实际上每个表通常是数百个），多个模式...你得到这个想法。 p>

我尝试使用SQL Server Management Studio的数据库图表功能，但是它遇到Win32Exception：没有足够的存储可用来处理此命令... p>

我试图在不同的机器上使用Visio的逆向工程功能来连接和图表，但是这已经进行了几个小时，没有完成迹象。

构建这个巨型模式的脚本正在通过我们为此工作构建的工具。虽然该工具正在做它的工作很好，它的可视化它的输出是棘手的。

我正在踢出一个这个数据库的图表的工具，所以我们可以做这个。任何建议？

编辑：
只是为了强调，这个图确实不应该用于实际的有用的参考。

解决方案

为数据库生成任何类型的图像，它是客户端关系管理设备，用于演示系统的复杂性/规模。这种尺寸的眼睛只是变成眼睛糖果，被卡在墙上，画出喘气，除了偶尔的眼光，老实说不出任何真正的目的。为什么不使用红门文档工具这样的工具来实现目的？请谅解我不是用这种嘲笑的方式说出来，但是在尝试绘制一个庞大的数据库之前，我已经走下了路，我在某种程度上取得了成功，但从来没有找到一个有用的地方。 / p>

I have a very large database I need to diagram. The database is SQL Server 2008 on x64. It is large in that there are hundreds of related tables, each with up to 2000 fields (some are sparse), multiple relationships between tables (often hundreds per table, in fact), multiple schemas... you get the idea.

I tried to use the Database Diagrams feature of SQL Server Management Studio, but it crashed with a Win32Exception: "Not enough storage is available to process this command..."

I tried to use Visio's reverse engineering feature on a different machine to connect in and diagram it, but that's been going for a few hours with no sign of completion.

The scripts to build this giant schema are being by a tool we built for the job. While the tool is doing its job just fine, it's tricky to visualise its output.

I'm after a tool to kick out a diagram of this database so we can do this. Any suggestions?

EDIT: Just to emphasize, the diagram is indeed not supposed to be used for actual useful reference. It's a client relationship management device to demonstrate the complexity/scale of the system.

解决方案

Generating an image of any kind for a database of that size simply becomes eye candy that is stuck on a wall that draw's gasps, and honestly serves no real purpose except occasional glances. Why not use a tool like Red Gate's Documentation tool that will serve an actual purpose? Please understand I'm not saying this in a mocking way, but I've been down this road before trying to diagram a huge database, and I succeeded to some degree, but never found a good outlet where it was of some use.

这篇关于如何生成一个非常大的数据库模式图（SQL Server）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！