Summary: | SQL export from entity relationship diagrams | ||
---|---|---|---|
Product: | [Applications] umbrello | Reporter: | Jonathan Riddell <jr> |
Component: | general | Assignee: | Umbrello Development Group <umbrello-devel> |
Status: | RESOLVED WORKSFORME | ||
Severity: | wishlist | CC: | finex, moz, opensource, sean.clarke |
Priority: | NOR | ||
Version: | unspecified | ||
Target Milestone: | --- | ||
Platform: | unspecified | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Attachments: |
error umbrello 64 bits fedora core 4
rails migration file example. |
Description
Jonathan Riddell
2004-12-17 19:27:07 UTC
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. |