用于 SQL Server 建模的 Sparx Enterprise Architect？
到目前为止，我的职业生涯中大部分数据库建模都使用 MS SQL Server Management Studio。我是一名数据库开发人员（不是 DBA），但对使用 Sparx 系统 Enterprise Architect 进行数据建模的好处感兴趣。我不需要为不同的数据库生成脚本，除此之外，使用 Sparx EA 能给我带来什么，而 SQL Management Studio 却不能呢？
I have used MS SQL Server Management Studio for most of my database modeling to this point in my career. I am a database developer (not a DBA), but interested in the benefits with using Sparx systems Enterprise Architect for data modeling. I do not have the need to generate scripts for different databases, other than that what does using Sparx EA buy me that SQL Management Studio does not?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
你不能将企业架构师视为一种开发工具。
企业架构师是一种为开发人员带来好处的建模工具。 EA 的主要特点是利用 UML 模型。 EA 使您可以灵活地以各种不同的方式对数据进行建模。您可以创建从逻辑到物理的所有级别的标准化模型。
它还允许您将其提升到一个新的水平，并对映射到您的概念模型的域类进行建模。
我还参与过采用 EA 模型并将其导出到 XMI 并运行基于规则的代码生成的项目。基本上根据图表生成了整个项目架构。
You can't think of enterprise architect as a development tool.
Enterprise architect is a modeling tool with developer benefits. The main feature of EA is to leverage UML models. EA gives you flexibility to model your data in all different ways. You can create all levels of standardized models from Logical to Physical.
It also allows you to take it to the next level and model domain classes that map to your conceptual model.
I have also been on projects that took EA models and exported them to XMI and ran rules based code generation. Which basically generated a whole project architecture based on diagrams.
我发现在负责构建和设计数据库和应用程序时使用 EA 具有优势。人们可以在域模型中对一般实体进行建模，然后使用转换功能从该模型创建表，同时以您选择的语言（例如 C#、C++ 或 Java）生成实体类。所以你会得到一点“二鸟一石”的效果。这可能不是每个人都认为的优势，但我喜欢它。
I found using EA an advantage when tasked with building and designing both the database and the application. One can model the general entities in a Domain Model then use the Transform feature to create tables from that model and at the same time generate entity classes in your language of choice (e.g C#, C++ or Java). So you get a bit of a "two birds with one stone" effect. This might not be what everyone sees as an advantage but I like it.
我意识到答案已经被标记为正确，但我想补充一点，您也可以将 SQL 逆向工程为概念模型。事实证明，这对我的工作来说是一个很有价值的功能。
另外，我个人使用 EA 生成数据库解决方案的设置脚本 ( http://www.marcusnordquist.com/ ？p=112）。
I realize that an answer has already been marked correct but I would like to add that you may also reverse engineer SQL to conceptual models. This has proved to be a valuable functionality for me in my work.
Plus, I personally use EA to generate setup scripts for DB solutions ( http://www.marcusnordquist.com/?p=112 ).