SQL 免费/便宜的 PowerDesigner 替代品？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/76350/
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
Free/cheap PowerDesigner alternative?
提问by David Vidmar
We are using PowerDesigner at work for database modelling. But there is a hell of a price tag on that piece of software. And frankly, all I use is physical diagrams for MS SQL, which is about 1% of what PD knows.
我们正在使用 PowerDesigner 进行数据库建模。但是该软件的价格非常高。坦率地说，我使用的只是 MS SQL 的物理图，这大约是 PD 知道的 1%。
Are there any good alternatives? I know about Visio and MS SQL Diagrams, but looking for other options.
有什么好的选择吗？我了解 Visio 和 MS SQL 图表，但正在寻找其他选项。
采纳答案by digiguru
I just use SQL Server using the diagrams folder. The designer is pretty simple to use, and can be used to generate tables fairly quickly. Considering it's free with the software, I don't see the issue.
我只是使用图表文件夹使用 SQL Server。设计器使用起来非常简单，可用于相当快地生成表格。考虑到软件是免费的，我没有看到这个问题。
回答by Huuuze
Power*Architectis the way to go. It's free, open source, and does a really great job helping you build your ERDs. Plus, it works on Windows, Linux, and OSX.
Power*Architect是必经之路。它是免费的、开源的，并且在帮助您构建 ERD 方面做得非常出色。此外，它适用于 Windows、Linux 和 OSX。
回答by Flaunt
Open System Architect: www.codebydesign.com - it does job for me perfect
开放系统架构师：www.codebydesign.com - 它对我来说很完美
回答by Brian Taylor
Check out Sparx Enterprise Architect also.
还可以查看 Sparx Enterprise Architect。
回答by mixtly87
How about MagicDraw? It is a very powerfull tool, but I think it as expensive as PowerDesigner, not sure.
MagicDraw怎么样？这是一个非常强大的工具，但我认为它和 PowerDesigner 一样昂贵，不确定。
回答by J. Coughlin
SourceForge.net Druid project
SourceForge.net Druid 项目
Has a templating engine to produce DDL or what ever you like. Has the ability to have multiple diagrams in one model. Only does physical data model. It is free and has source available. It is a java based tool so it will run on Unix or Windows.
有一个模板引擎来生成 DDL 或任何你喜欢的东西。能够在一个模型中包含多个图表。只做物理数据模型。它是免费的，并且有可用的资源。它是一个基于 Java 的工具，因此可以在 Unix 或 Windows 上运行。
回答by SarekOfVulcan
You might want to look at https://www.xcase.com/demo.php. It's not free, but it's quite a bit cheaper than PowerDesigner, as far as I can tell. I've used earlier versions, but lately I've had easy access to Visio, so have continued with that instead of investing in xCase.
您可能想查看https://www.xcase.com/demo.php。它不是免费的，但据我所知，它比 PowerDesigner 便宜很多。我使用过早期版本，但最近我可以轻松访问 Visio，所以继续使用它而不是投资 xCase。
回答by ConcernedOfTunbridgeWells
The version of Visio that comes with VS Enterprise Architect has a forward-engineer feature that will generate SQL. There is also a type library for the modelling engine, but (on older versions at least) it won't extract certain items such as comments. However, the generated SQL has the comments in a fairly simple structure that does facilitate parsing the generated SQL.
VS Enterprise Architect 附带的 Visio 版本具有可生成 SQL 的前向工程师功能。建模引擎还有一个类型库，但（至少在旧版本中）它不会提取某些项目，例如注释。但是，生成的 SQL 具有相当简单结构的注释，这确实有助于解析生成的 SQL。
You can get older versions of VS enterprise architect on E-bay for not very much money (I think mine cost about ￡250).
您可以在 E-bay 上获得旧版本的 VS 企业架构师，花费不多（我认为我的成本约为 250 英镑）。
One caveat for reverse-engineers is that all pre-VS2005 visio DB modelling engines will not play nicely with the SQL Server 2005 native client. You need to either script out the database and re-load it on a SQL2000 server (dealing with SQL2005 specific features such as schemas is left as an exercise for the reader) or get a more recent version.
对逆向工程师的一个警告是，所有 VS2005 之前的 visio DB 建模引擎都不能很好地与 SQL Server 2005 本机客户端配合使用。您需要编写数据库脚本并将其重新加载到 SQL2000 服务器上（处理 SQL2005 特定功能，例如模式留给读者作为练习），或者获取更新的版本。
回答by ConcernedOfTunbridgeWells
Well there's another alternative. Use it for more than just making tables! Exploit it, get your money's worth. You've already paid for it, you could drop the maintenance and just use it as-is. Anyways, something to ponder.
那么还有另一种选择。使用它不仅仅是制作桌子！利用它，让你的钱物有所值。您已经支付了费用，您可以放弃维护并按原样使用它。总之，有什么值得深思的。
