# Database ER Digram \<=\> Rails Migrations Files : Does such a

**URL:** <https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847>\
**Category:** Rails\
**Created:** [March 23, 2007, 8:17am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847 "2007-03-23T08:17:01Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 23, 2007, 8:17am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/1 "2007-03-23T08:17:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 23, 2007, 8:41am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/2 "2007-03-23T08:41:39Z")

</div>

No

On Mar 22, 9:16 pm, “Greg H.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 26, 2007, 2:11am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/3 "2007-03-26T02:11:32Z")

</div>

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

On Mar 23, 12:16 am, “Greg H.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 26, 2007, 1:14pm UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/4 "2007-03-26T13:14:24Z")

</div>

On 26 Mar 2007, at 01:01, removed\_email\_address@domain.invalid wrote:

> 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. 🙂

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

Thanks and regards,  
Andy S.

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 26, 2007, 11:01pm UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/5 "2007-03-26T23:01:03Z")

</div>

> 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/](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](http://www.egenial.com.br/er)

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

- Mark.

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 27, 2007, 4:44am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/6 "2007-03-27T04:44:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [March 27, 2007, 10:40am UTC](https://www.ruby-forum.com/t/database-er-digram-rails-migrations-files-does-such-a/89847/7 "2007-03-27T10:40:46Z")

</div>

On 26 Mar 2007, at 22:00, Mark T. wrote:

> Here’s an E-R diagramming tool that can output Rails migrations (Mac  
> only):  
> [SQLEditor for Mac OS X](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](http://www.egenial.com.br/er)
> 
> (and here’s the omnigraffle link: [http://www.hackdiary.com/archives/](http://www.hackdiary.com/archives/)  
> 000093.html)

Excellent, thank you for those links.

Regards,  
Andy S.