SQL 什么是好的 Visio Enterprise Architect 替代品？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/272816/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is a good Visio Enterprise Architect replacement?
提问by MattValerio
I've been using Visio 2002/2003 Enterprise Architect to do my database schema design visually and then forward-generate the DDL to create the database.
我一直在使用 Visio 2002/2003 Enterprise Architect 以可视化方式进行我的数据库架构设计，然后正向生成 DDL 以创建数据库。
I wanted to switch to Visio 2007, but while it does have database diagramming support, it doesn'thave the ability to generate DDL. Bummer.
我想切换到 Visio 2007，但虽然它确实有数据库图表支持，但它没有生成 DDL 的能力。无赖。
I am really disappointed because it seems like Microsoft has completely abandoned this feature. You can't do it in Visual Studio (that I've found). You can sorta do it with SQL Server Management Studio if you insert database diagrams into your database, but any edits to the schema immediately take effect.
我真的很失望，因为微软似乎完全放弃了这个功能。你不能在 Visual Studio 中做到这一点（我已经找到了）。如果您将数据库图表插入到您的数据库中，您可以使用 SQL Server Management Studio 执行此操作，但对架构的任何编辑都会立即生效。
Has anyone found a good program to do this? I'm hoping to find one that is free and can generate DDL/SQL for SQL Server.
有没有人找到一个好的程序来做到这一点？我希望找到一个免费的并且可以为 SQL Server 生成 DDL/SQL 的软件。
回答by Brian Schneeberg
Unfortunately, I have recently faced the same problem, hoping that MS would provide a new version of Visio Enterprise Architect since I have used it FOREVER to do ERDs/database design. Since this does not seem to be forthcoming from them however, I have been forced to research other tools. The ones I checked out included the following:
不幸的是，我最近遇到了同样的问题，希望 MS 提供一个新版本的 Visio Enterprise Architect，因为我一直使用它来进行 ERD/数据库设计。然而，由于这似乎不是他们提供的，我被迫研究其他工具。我检查过的包括以下内容：
- Embarcadero ER/Studio
- Visual Paradigm DB Visual Architect
- Altova DatabaseSpy
- Dezign for Databases
- Sybase PowerDesigner
- Embarcadero 急诊室/工作室
- Visual Paradigm DB 视觉架构师
- Altova 数据库间谍
- 数据库设计
- Sybase PowerDesigner
Also, I tried to check out DevGEMS Data Modeler but kept getting "the setup files are corrupted" after downloading it. I never considered ERWin as the interface seems too old school/legacy plus it is too expensive. Just when I had almost given up all hope of finding a well-rounded but [relatively] cheap alternative I came across ModelRight. I find it curious that I haven't heard more about this company given that their product is EXCELLENT and inexpensive (under $1000 for multi-DB support or under $500 for a single DB type) compared to other high-end DB modeling tools. Further, the company was founded by one of the first developers to work on ERwin (see their company's "About" page for more info).
此外，我尝试查看 DevGEMS Data Modeler，但在下载后一直收到“安装文件已损坏”。我从来没有考虑过 ERWin，因为界面看起来太老派/传统，而且太贵了。就在我几乎放弃寻找全面但[相对]便宜的替代品的所有希望时，我遇到了ModelRight。我觉得奇怪的是，我没有听说过关于这家公司的更多信息，因为与其他高端数据库建模工具相比，他们的产品非常出色且价格低廉（多数据库支持低于 1000 美元，单个数据库类型低于 500 美元）。此外，该公司是由最早在 ERwin 上工作的开发人员之一创立的（有关更多信息，请参阅他们公司的“关于”页面）。
To make a long story short, if you want to save yourself a day's worth of research on this subject, check out ModelRight FIRST and go from there. BTW, for full disclosure - I have no affiliation with the ModelRight company! ;^)
长话短说，如果您想节省一天的时间来研究这个主题，请先查看 ModelRight 并从那里开始。顺便说一句，为了全面披露 - 我与 ModelRight 公司没有任何关系！;^)
P.S. - From what I can tell currently, VS 2010 isn't going to offer a full DB modeling environment but only enough to support the Entity Framework which I am not currently sold on (especially having spent the time to roll my own ORM layer).
PS - 据我目前所知，VS 2010 不会提供完整的 DB 建模环境，但仅足以支持我目前未出售的实体框架（尤其是花时间滚动我自己的 ORM 层） .
回答by MobyDX
This functionality is only available in the "for Enterprise Architects"-edition of Visio. This edition is apparently not sold as a stand-alone product, but it is included in MSDN Premium.
此功能仅在 Visio 的“适用于企业架构师”版本中可用。此版本显然不是作为独立产品出售的，但它包含在 MSDN Premium 中。
See this article on Office Online: What happened to the Generate and Update commands on the Database menu?
请参阅 Office Online 上的这篇文章：“数据库”菜单上的“生成”和“更新”命令发生了什么变化？
回答by zendar
Not free, but very good and simple to use: Dezign for Databases
不是免费的，但非常好且易于使用：Dezign for Databases
Draw your model and then you can generate DDL for lots of different databases.
绘制您的模型，然后您可以为许多不同的数据库生成 DDL。
回答by Patrick Desjardins
I use Sparks Enterprise Architect. It can create the basic by taking all your database with an ODBC than you can design and reverse change too. It's not free.
我使用Sparks Enterprise Architect。它可以通过使用 ODBC 获取所有数据库来创建基本数据库，而您也可以设计和反向更改。它不是免费的。
回答by dkretz
Oh, and DBDesigner is pretty good, and free.
哦，DBDesigner 很不错，而且是免费的。
回答by dkretz
I got tired of hand-coding my DDL from Visio 2007 Diagrams, so I wrote a script to do it for me. I know it's not perfect. But, it works for me. You are welcome to try it out at aboutwhatever.net/posts/visio-2007-database-model-ddl-generation. If there is enough interest, I will look into expanding it's capabilities.
我厌倦了从 Visio 2007 Diagrams 手动编码我的 DDL，所以我写了一个脚本来为我做这件事。我知道这并不完美。但是，它对我有用。欢迎您在aboutwhatever.net/posts/visio-2007-database-model-ddl-generation 上试用。如果有足够的兴趣，我会考虑扩展它的功能。
回答by KristoferA
The 'big' ones are CA's ErWinand Embarcadero's ErStudio.
“大”的是CA 的 ErWin和Embarcadero 的 ErStudio。
On a side-note, Microsoft appear to have realized the need for modelling tools so they're working on some new modelling tools ("Oslo") that will [probably] be included in VS 2010.
附带说明一下，Microsoft 似乎已经意识到对建模工具的需求，因此他们正在开发一些新的建模工具（“Oslo”），这些工具[可能] 将包含在 VS 2010 中。
回答by dkretz
If you are referring to the Object Role Model diagrams, you can google for that, or for Terry Halpern.
如果您指的是对象角色模型图，您可以通过谷歌搜索或搜索 Terry Halpern。
I reverted to VisioModeler, which is available free (but unsupported) at
我恢复到 VisioModeler，它可以免费（但不受支持）在
回答by PositiveGuy
I found Visio to be useful for 2 things:
我发现 Visio 对两件事很有用：
1) Flows (flowcharts, wireframing, sitemaps) 2) Reverse engineering Databases
1) 流程（流程图、线框图、站点地图） 2) 逆向工程数据库
other than that, it's really of no use. But still valuable for those things.
除此之外，真的没有任何用处。但是对于那些东西还是有价值的。
Enterprise Architect is the only way to go with DB Modeling.
Enterprise Architect 是使用 DB Modeling 的唯一方法。
回答by w0lf
I recommend Sybase Power Designer
It's easy to use, intuitive, offers partial SQL DDL preview (for selected objects) and uses scripts for automation. The scripting feature is not very well documented, but after reading some of their sample scripts I was able to do what I wanted.
它易于使用、直观，提供部分 SQL DDL 预览（针对选定对象）并使用脚本进行自动化。脚本功能没有很好的文档记录，但在阅读了他们的一些示例脚本后，我能够做我想做的事。
