SQL数据建模/映射软件为200+表 [英] SQL Data Modelling/Mapping Software for 200+ Tables
问题描述
我在寻找我认为是所谓的数据建模程序，将我们所有的SQL Server表（200+）映射成一个大的海报大小的图像。我们把所有的遗留应用程序表放到SQL Server 2005中，我的老板正在寻找一种奇怪的方式来查看数据...基本上是说这是我们维护的。
I'm looking for what I think is called a data modeling program to map out all of our SQL Server tables (200+) into a large, poster-size image. We've put all of our legacy application tables into SQL Server 2005 and my boss is looking for a snazzy way of viewing the data... basically something to say "this is what we maintain".
我看过一些非常大的数据库书籍，为不同的公司多年来，但没有什么像我正在寻找现在。我已经下载了一个称为ModelRight的程序，它做了重新设计，但似乎限制在约70表...之后，表开始堆叠在彼此的顶部。企业和遗留应用程序可以拥有大量的数据库，所以这个想法不可能是新的，但我找不到任何我想要做的事情。
I've seen some very big database books for different companies over the years, but nothing like what I'm looking for now. I have downloaded a program called ModelRight and it does the re-engineering, but it seems to be limited to about 70 tables... after that the tables start stacking on top of each other. Enterprise and legacy applications can have massive databases so this idea can't be new, but I cannot find anything to do what I'm looking to do.
应用程序将是最好的，但企业级数据库可能会花费企业级的现金！有没有人做过这样的事情，你使用什么？任何提示将非常感谢！
Of course open-sourced applications would be the best, but enterprise-level databases will probably cost enterprising-level cash! Has anyone ever done anything like this and what did you use? Any tips would be greatly appreciated!
推荐答案
有许多产品可以执行此操作：
There are a number of products that do this:
- SQL Modeler（来自Sybase数据库工作室）
- ERWin
- Visio
- System Architect
- Eclipse加上ER Modeler插件
- Sql Server Management Studio 2005和2008支持ER模型，可以从数据库
- SQL Modeler (from Sybase Database studio)
- ERWin
- Visio
- System Architect
- Eclipse plus the ER Modeler plugin
- Sql Server Management Studio 2005 and 2008 supports ER models and can auto generate the diagram from a database (although it's up to you to lay out the diagram sensibly)
这里是一个 site 比较大量或ER建模工具
Here is a site that compares a large number or ER Modeling tools
如果您有Visual Studio Team System数据库版本，您可以将该数据库反向工程为实体模型。
If you have Visual Studio Team System Database edition you can reverse engineer that database into an Entity Model.
这篇关于SQL数据建模/映射软件为200+表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
