blocks|key|3821404|text|我只是通过图表文件夹来使用SQL+Server。设计器使用起来非常简单，并且可以用来快速生成表。考虑到软件是免费的，我看不出有什么问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3821405|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|5231778|text|你可能想看看https://www.xcase.com/demo.php。它不是免费的，但据我所知，它比PowerDesigner便宜得多。我使用过早期的版本，但最近我可以很容易地使用Visio，所以我继续使用它，而不是投资于xCase。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5231779|entityMap|0|LINK|mutability|MUTABLE|url|https://www.xcase.com/demo.php^0|6|U|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You might want to look at <a href="https://www.xcase.com/demo.php" rel="nofollow noreferrer">https://www.xcase.com/demo.php</a>. 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.

blocks|key|5231849|text|VS+Enterprise+Architect附带的Visio版本具有可生成SQL的前向工程功能。还有一个用于建模引擎的类型库，但(至少在旧版本中)它不会提取某些项，如注释。但是，生成的SQL具有相当简单的结构中的注释，这确实有助于解析生成的SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5231850|你可以在E-bay上获得VS+enterprise+architect的旧版本，花费不是很多(我想我的成本大约是250£)。|5231851|逆向工程师需要注意的一点是，所有VS2005之前版本的visio+DB建模引擎都不能很好地与SQL+Server+2005本机客户端配合使用。您需要编写数据库脚本并将其重新加载到SQL2000服务器上(模式等特定于SQL2005的特性的处理留给读者作为练习)，或者获取更新的版本。|5231852|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

You can get older versions of VS enterprise architect on E-bay for not very much money (I think mine cost about £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.

blocks|key|3821583|text|好吧，还有另一种选择。使用它不仅仅是制作表格！利用它，让你的钱物有所值。你已经付钱了，你可以放弃维护，按原样使用它。无论如何，一些值得深思的事情。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3821584|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|2977510|text|Power*Architect是最好的选择。它是免费的，开源的，非常好的帮助你构建你的ERD。此外，它还可以在Windows、Linux和OSX上运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2977511|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlpower.ca/page/architect^0|0|F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.sqlpower.ca/page/architect" rel="noreferrer">Power*Architect</a> is 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.

blocks|key|5232067|text|开放系统架构师:+www.codebydesign.com+-它为我做了完美的工作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5232068|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Open System Architect: www.codebydesign.com - it does job for me perfect

blocks|key|2977590|text|SourceForge.net+Druid项目|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2977591|有一个模板引擎来生成DDL或任何你喜欢的东西。能够在一个模型中包含多个图。只有物理数据模型。它是免费的，并且有可用的源码。它是一个基于java的工具，所以它可以在Unix或Windows上运行。|2977592|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

SourceForge.net Druid project

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.

blocks|key|3821877|text|也可以查看Sparx+Enterprise+Architect。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3821878|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check out Sparx Enterprise Architect also.

blocks|key|2977862|text|那MagicDraw呢？这是一个非常强大的工具，但我认为它和PowerDesigner一样昂贵，我不确定。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2977863|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

How about MagicDraw? It is a very powerfull tool, but I think it as expensive as PowerDesigner, not sure.

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.

Are there any good alternatives? I know about Visio and MS SQL Diagrams, but looking for other options.

Free/cheap PowerDesigner alternative?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我们在工作中使用PowerDesigner进行数据库建模。但这款软件的价格实在是高得离谱。坦率地说，我使用的都是MS SQL的物理图，大约是PD所知道的1%。有什么好的选择吗？我知道Visio和MS SQL图表，但正在寻找其他选项。

问免费/便宜的PowerDesigner替代品？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问免费/便宜的PowerDesigner替代品？EN