I'm looking for a free or paid software application that I can use for ER modelling.
Since I mostly develop applications using Symfony2/Doctrine, does anyone know about software that has Doctrine support?
I'm looking for a free or paid software application that I can use for ER modelling.
Since I mostly develop applications using Symfony2/Doctrine, does anyone know about software that has Doctrine support?
This may not interest you directly, and is probably not really fitting your current development cycle either, but I think it's a good approach to avoid code generation wherever possible.
I'm currently developing the modules integration of Doctrine ORM with ZF2, and we got to build a tool that creates on-the-fly graphs of your entities relations:
(please don't take the graph as a good example)
With this approach, you write entities first, then mappings (annotations/xml/yaml/php) and there you got your schema (displayed by your application). I'm considering pushing this to doctrine/common directly, so it may be available in the DoctrineBundle soon.
I think the following comparison is what you're searching: http://www.orm-designer.com/article/orm-designer-and-mysql-workbench-comparison
Conclusion: both ORM Designer and MySQL workbench are able to work with Doctrine.
Since MySQL workbench is free and under the wings of MySQL itself this should be favorable to me.
Take a look at ORM Designer.
I always use MySQL Workbench and then import my database schema into doctrine entities. This let me fine-tune my indices better that way.