SQL Server数据库到UML [英] SQL server database to UML

问题描述

嗨
有什么方法或程序将sql server数据库转换为UML图(用例，类，序列)?

希望你能帮助我

当然，谢谢

Hi
Is there any way or program converts sql server database to UML diagrams ( use case, class, sequence ) ??

I hope you help me

Thanks

推荐答案

是的，但前提是您的数据库已经具有支持可映射到UML的结构的模式，或者您可以使用以下方法演化或创建这样的模式:您的数据库.有了它后，就可以使用映射代码创建数据结构来支持UML.基本上，创建此类映射代码是在软件中使用关系数据库(尤其是面向对象)的主要和基本的杂务工作.

现在就这样了，因为……从活动的主要目标开始，您几乎没有指定与问题相关的任何内容.请参阅我对您问题的评论.因此，基于我上面解释的想法，您需要创建需求，项目的总体草图，体系结构，设计组件，实现……只是从头到尾.

这看起来是一个非常认真的项目.虽然这是完全可行的，但我想说，成功是有保证的，但是……如果您仍然没有头绪，那么我想说，您需要从雇用系统架构师和/或首席开发人员开始.认真.

—SA

Yes, of course, but only if your database already has a schema supporting structures which can be mapped onto UML or if you can evolve or create such schema with your database. When you have it, you can create data structures to support UML with a mapping code. Basically, creating of such a mapping code is the main and fundamental kind of programming chores in using relational databases in software, especially object-oriented.

Now, this is it, because… you did not specify almost nothing relevant to the problem, starting with the main goals of your activity. Please see my comments to your question. So, based on the idea I explained above, you need to create requirements, general sketch of the project, architecture, design components, implementation… just to start and to end.

This would look like a pretty serious project. It is perfectly feasible though, and I would say, success is guaranteed, but… If you still have no clue, well, I would say you need to start with hiring a system architect and/or leading developer. Seriously.

—SA

是的，可以使用EF Power Tools CTP1.您可以从code first mapping生成只读的EDMX.它是not UML，但它是same diagram you had with model first.
EF电动工具CTP1已发布

Yes, you can by using EF Power Tools CTP1. You can generate read-only EDMX from your code first mapping. It is not UML but it is the same diagram you had with model first.
EF Power Tools CTP1 Released

这篇关于SQL Server数据库到UML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！