Version: (using KDE Devel) Entity relationship diagrams should be able to export SQL.
yes ! import too ;) from a SQL-DDL create tables and stuff
This would be a fantastic addition.
Created attachment 13236 [details] error umbrello 64 bits fedora core 4 error umbrello fedora core 4 64 bits
... export and import (at least from MySQL) would make this fantastic app even more useful ...
having your project file in sync with a MySQL database would be even better.
I need this quite fast, but I've not much knowledge in programming. How is an export function written? Is there an example and a howto? If it's not too complicated, I would start writing a simple one. For me, even a text-export would be helpful.
What should the generated code look like? Please attach example diagrams and the corresponding intended SQL at least for the most important use cases.
Created attachment 16634 [details] rails migration file example. having my umbrello ERD in sync with anything would be really what I am whissing for. mysql database sqlite database file (kexi) .sql DDL text file .rb ruby on rails migration file. but as a first step, an export function would be really sweet. I am posting this comment to add that I wish the export function could let me choose between SQL or Rails migration code. as an attachment I will put a rails database migration file. then activerecord generated the proper SQL for whatever database backend I am using. note that the ID(autoincrement) is automatic and must not be shown in the migration file. thank you.
The patch I once had was very specific to my diagram and is lost now. :-(
SQL Export from E-R diagram works on current trunk.