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

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

No

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. :slight_smile:

- Dan

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

Thanks and regards,
Andy Stewart

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.

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

Excellent, thank you for those links.

Regards,
Andy Stewart