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?
+1
A:
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.
Nix
2010-05-18 02:44:09
I'm already planning on using EA for an upcoming project for the overall model, just trying to decide if I should use EA for detailed data model as well instead of sql server diagrams (which is what I normally use).
Tone
2010-05-18 11:01:27