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.
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.
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.
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.
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.
Visual Studio 2010 Beta 1 has some pretty cool tools for data modeling, especially the ADO .Net Entity Data Model Tools. And yes, you can generate DDL from the models.
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:
Embarcadero ER/Studio
Visual Paradigm DB Visual Architect
Altova DatabaseSpy
Dezign for Databases
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).
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! ;^)
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).
发布评论
评论（11）
此功能仅在 Visio 的“面向企业架构师”版本中可用。 该版本显然不作为独立产品出售，但它包含在 MSDN Premium 中。
请参阅 Office Online 上的这篇文章：“数据库”菜单上的“生成”和“更新”命令发生了什么情况？
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.
See this article on Office Online: What happened to the Generate and Update commands on the Database menu?
不是免费的，但非常好且易于使用：Dezign for Databases
绘制模型并然后您可以为许多不同的数据库生成 DDL。
Not free, but very good and simple to use: Dezign for Databases
Draw your model and then you can generate DDL for lots of different databases.
我使用 Sparks Enterprise Architect。 它可以通过使用 ODBC 获取所有数据库来创建基础，而不是您可以设计和反向更改。 它不是免费的。
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.
哦，DBDesigner 非常好，而且免费。
http://www.fabforce.net/downloads.php
Oh, and DBDesigner is pretty good, and free.
http://www.fabforce.net/downloads.php
如果您指的是对象角色模型图，您可以通过谷歌搜索，或者搜索 Terry Halpern。
免费获取（但不受支持）
我恢复到 VisioModeler，它可以在http://www.microsoft.com/downloads/details.aspx?familyId=27fe6786-a439-4286-b8b6-7a9b84cfa709&displaylang=en
If you are referring to the Object Role Model diagrams, you can google for that, or for Terry Halpern.
I reverted to VisioModeler, which is available free (but unsupported) at
http://www.microsoft.com/downloads/details.aspx?familyId=27fe6786-a439-4286-b8b6-7a9b84cfa709&displaylang=en
“大”的是 CA 的 ErWin 和 Embarcadero 的 ErStudio。
顺便说一句，微软似乎已经意识到对建模工具的需求，因此他们正在开发一些新的建模工具（"Oslo") 将[可能]包含在 VS 2010 中。
The 'big' ones are CA's ErWin and Embarcadero's 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.
我厌倦了从 Visio 2007 图表中手动编码 DDL，因此我编写了一个脚本来帮我完成这件事。 我知道这并不完美。 但是，它对我有用。 欢迎您在 aboutwhatever.net/posts/visio 进行尝试-2007-数据库模型-ddl-生成。 如果有足够的兴趣，我将考虑扩展其功能。
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 对两件事很有用：
1) 流程（流程图、线框图、站点地图）
2）逆向工程
除此之外的数据库，真的没有什么用处。 但对于那些东西来说仍然有价值。
Enterprise Architect 是进行数据库建模的唯一方法。
I found Visio to be useful for 2 things:
1) Flows (flowcharts, wireframing, sitemaps)
2) Reverse engineering Databases
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.
我推荐 Sybase Power Designer
它易于使用、直观，提供部分 SQL DDL 预览（对于选定的对象）并使用脚本进行自动化。
脚本功能没有很好的记录，但是在阅读了他们的一些示例脚本后，我能够做我想做的事情。
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.
Visual Studio 2010 Beta 1 有一些非常酷的数据建模工具，尤其是 ADO .Net 实体数据模型工具。 是的，您可以从模型生成 DDL。
Visual Studio 2010 Beta 1 has some pretty cool tools for data modeling, especially the ADO .Net Entity Data Model Tools. And yes, you can generate DDL from the models.
不幸的是，我最近遇到了同样的问题，希望 MS 能够提供新版本的 Visio Enterprise Architect，因为我一直使用它来进行 ERD/数据库设计。 然而，由于他们似乎没有提供这一点，我被迫研究其他工具。 我检查过的包括以下内容：
另外，我尝试检查 DevGEMS Data Modeler，但下载后一直收到“安装文件已损坏”的信息。 我从来没有考虑过 ERWin，因为它的界面看起来太老派/传统，而且价格太贵。 就在我几乎放弃寻找全面但[相对]便宜的替代方案的所有希望时，我遇到了ModelRight< /a>。 我觉得奇怪的是，我没有听说过更多关于这家公司的信息，因为与其他高端数据库建模工具相比，他们的产品非常出色且便宜（多数据库支持低于 1000 美元，单个数据库类型低于 500 美元）。 此外，该公司是由第一批从事 ERwin 开发的开发人员之一创立的（有关更多信息，请参阅其公司的“关于”页面）。
长话短说，如果您想节省一天的时间来研究这个主题，请先查看 ModelRight 并从那里开始。 顺便说一句，全面披露 - 我与 ModelRight 公司没有任何隶属关系！ ;^)
PS - 据我目前所知，VS 2010 不会提供完整的数据库建模环境，但仅足以支持我目前不出售的实体框架（尤其是花时间推出我自己的实体框架） ORM 层）。
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:
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).
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! ;^)
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).