用于 SQL Server ERD 和正向工程的廉价工具？
过去，当我们处于概念设计阶段时，我曾使用 Visio（2003 Professional，如果有的话）来绘制数据库图表。不过，这是非常痛苦的，因为没有好的方法可以从 Visio 中获取数据（尽管 这个答案给了我暂时止痛的希望）。由于设计通常都很小，所以这种痛苦并没有变得太严重。但我真的很想找到一个更好、更少痛苦、更可持续的解决方案。
我对这个产品类别唯一的真实经验是非常古老的（比如十年前的 ER/Studio），所以我不知道今天的情况是什么样的。我在 StackOverflow 上查看了一下，我能找到的与我的问题唯一接近的匹配并不是很令人鼓舞。以下是我的基本要求：
- 离线工作。这是我不只使用 SSMS 图表的主要原因。有时，我只想扔掉图表（可能是半成品设计），并与其他人一起完善它们，直到我们准备好实例化真正的数据库。
- 支持 SQL Server 2000+。其他数据库也不错，但我们 99% 的数据库都是 SQL Server，而且大部分是 2000，少数是 2005。
- 只是图表。 其中很多工具都是一些综合性 DBA 或模型架构师套件的一部分，其中包含性能工具或某种建模过程。如果它们不妨碍我，我不一定反对拥有这些选项，但我们都< em>需要是 SQL DDL 的图表和正向工程。 （不过，逆向工程会很好。）
- 不会花很多钱。我知道，这是一个棘手的问题（而且也相当主观）。但我们并不是在与一些功能失调的大型企业团队合作。只有少数开发人员偶尔需要研究更复杂的数据库。我根本不可能获得 5000 美元工具的批准。
我正在寻找的产品是否存在？
编辑：经过一番探索，我发现了一些看起来很有希望的东西；有人有使用这些工具的经验吗？
- ModelRight，由 ModelRight, Inc.
- BDB，Bainsoft 出品（我对这个有点警惕，因为 Google 大多会为可疑的“很棒的软件下载！”提供点击页面。网站）
- Aqua Data Studio，Aquafold（主要是 SSMS 等工具的替代品，但确实内置了 ER 建模器）在）
In the past, I've used Visio (2003 Professional, if it matters) to doodle database diagrams while we're in the conceptual design phase. This is pretty painful, though, because there's no good way to get the data out of Visio (though this answer gives me hope of a temporary analgesic). Since the designs are generally pretty small, that pain hasn't gotten too bad. But I'd really like to find a better, less painful, more sustainable solution.
My only real experience with this product category is very old (like, ER/Studio a decade ago), so I have no idea what the landscape looks like today. I've looked around on StackOverflow, and the only close match to my question I could find wasn't very encouraging. Here are my basic requirements:
- Works offline. This is my major reason for not just using SSMS's diagramming. There are times when I just want to throw diagrams around, possibly of half-finished designs, and refine them with others until we're ready to instantiate the real database.
- Supports SQL Server 2000+. Other databases are nice, but 99% of our DBs are SQL Server, and most of them are 2000, with a few 2005.
- Just the diagrams. A lot of these tools are part of some comprehensive DBA or Model Architect Suite with performance tools or some kind of modeling process baked in. I don't necessarily object to having those options if they stay out of the way, but all we need is diagramming, and forward-engineering of the SQL DDL. (Reverse engineering would be nice, though.)
- Can't cost an arm and a leg. This is the tricky one, I know (and also pretty subjective). But we aren't working some giant dysfunctional enterprise team. It's just a handful of developers that occasionally have a more complicated database to chew over. There's no way in heck I'm getting approval for a $5000 tool.
Does the product I'm looking for even exist?
EDIT: In a little poking around, I turned up a couple of things that look kind of promising; anyone have any experience with these tools?
- ModelRight, by ModelRight, Inc.
- BDB, by Bainsoft (I'm a little wary of this one, since Google mostly turns up pages of hits for shady "great software downloads!" sites)
- Aqua Data Studio, by Aquafold (mostly a replacement for tools like SSMS, but does have an ER modeler built in)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
Quest Software 有一个名为 Toad Data Modeler 的工具，该工具不是免费的，但并不免费也不花一条胳膊和一条腿。
它质量高、非常实用、非常强大。如果您认真对待专业环境中的数据建模，绝对值得一看。
马克
Quest Software has a tool called Toad Data Modeler which is not free, but doesn't cost an arm and a leg either.
It's high quality, very usable, very powerful. Definitely worth a look if you're serious about data modelling in a professional environment.
Marc
我已经将 Dia 与 SQL 帮助程序脚本一起用于此类事情。迪亚是免费的。 SQL 生成器是 Dia2SQL。请参阅此处获取一些链接。这是 Dia 的 Windows 安装程序
I have use Dia with SQL helper scripts for this kind of thing. Dia is free. A SQL generator is Dia2SQL. See here for some links. And here is a Windows installer for Dia
有许多工具可用于 SQL Server ERD 和正向工程，例如：Erwin Data Modeler、Data Workbench、Enterprise Architect、ER Studio、Toad Data Modeler。
A number of tools are available for SQL Server ERDs and forward-engineering like: Erwin Data Modeler, Data Workbench, Enterprise Architect, ER Studio, Toad Data Modeler.