Database ER Digram <=> Rails Migrations Files : Does such a tool exist?

[Greg_H]

Hi all,

Does anyone know if there is a round-tripping tool for “Database ER Digram” <=> “Rails Migrations Files” available? That is to:

1. Visually plan your database (UML ER diagram) => export Rails Migrations Files &

2. Ability to modify Rails Migration Files and then => read these files and produce a visual Database UML ER digram

Thanks
Greg

[dysinger]

No

[doktahworm (doktahworm@gmail.com)]

This isn't what you're specifically looking for, but it's an article
about how to generate E-R diagrams from your Models using OmniGraffle
(awesome Mac-only charting app).

Sorry I don't have a solution, just a pointer, but it's a pointer
nonetheless.

- Dan

[Andrew_Stewart]

I can't seem to see your pointer -- could you please post it (again)?

Thanks and regards,
Andy Stewart

[Mark_Thomas2 (Mark Thomas)]

Does anyone know if there is a round-tripping tool for "Database ER Digram"
<=> "Rails Migrations Files" available? That is to:

1) Visually plan your database (UML ER diagram) => export Rails Migrations
Files

Here's an E-R diagramming tool that can output Rails migrations (Mac
only):
http://www.malcolmhardie.com/sqleditor/cocoa/

Here's a beta of a slick online one that's all web2.0 and ajaxy:
http://www.egenial.com.br/er

(and here's the omnigraffle link: http://www.hackdiary.com/archives/000093.html)

- Mark.

[Greg_H]

have you tried SQLEditor Mark? Is it solid/stable? Is there good support? (i.e. from MalcolmHardie Solutions?)

[Andrew_Stewart]

Excellent, thank you for those links.

Regards,
Andy Stewart