ER Studio is not only a comprehensive and robust data modeling tool - but it is designed and developed by a team that clearly understands data modeling needs and industry trends. A long time ago CA's ERwin was the tool of choice, but these days ER Studio provides as much or more functionality with a much clearer vision or product strategy. It also generates some of the best DDL from a data modeling tool - often requiring zero changes or modifications before executing.
What do you dislike?
there are a few too many "editions" - it ought to all just be one inclusive offering
Recommendations to others considering the product
When evaluating data modeling tools make sure not to only evaluate the diagramming aspects of the tool as the picture is only the tip of the iceberg. Good data models contain lots of metadata that's behind the picture and which results in higher quality database designs. Most freeware or shareware tools do a decent picture, but lack the metadata. So it's worth paying for a quality tool.
What business problems are you solving with the product? What benefits have you realized?
capturing and recording true business requirements and transforming them into a cohesive database design that is both effective and efficient.
* We monitor all ER/Studio reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.