I'm a user of the Symfony MVC framework for PHP (http://www.symfony-project.com). One of the great advantages of Symfony is that it uses Propel as the db abstraction layer.
The problem is that you have to create your schema in xml for it to then create the SQL statements. The only tools I have found that work and for which there are propel converters are:
– DBDesigner (fabForce.net), open source but lacks features
– MySQL Workbench, nice ui but currently in alpha and doesn't support export to XML schema
So I'm wondering if SQLyog can be extented to be a schema designer/editor with a capability of exporting to different xml schemas.
Thanks for listening 🙂