# SQL tool

**URL:** <https://www.ruby-forum.com/t/sql-tool/156530>\
**Category:** Rails\
**Created:** [December 29, 2008, 4:29pm UTC](https://www.ruby-forum.com/t/sql-tool/156530 "2008-12-29T16:29:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vanight](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/a698b9/32.png) [@vanight](https://www.ruby-forum.com/u/vanight)\
**Post date:** [December 29, 2008, 4:29pm UTC](https://www.ruby-forum.com/t/sql-tool/156530/1 "2008-12-29T16:29:28Z")

</div>

Hi,

I’m looking for a tools under windows that can draw a SQL map using a  
sql file and ruby convention. So relations are kept and I can get a nice  
gif or jpeg file  
with my DB schema.

Thanks 🙂

---

<div class="post-metadata">

**Author:** ![vanight](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/a698b9/32.png) [@vanight](https://www.ruby-forum.com/u/vanight)\
**Post date:** [December 29, 2008, 10:13pm UTC](https://www.ruby-forum.com/t/sql-tool/156530/2 "2008-12-29T22:13:02Z")

</div>

On Dec 29, 10:29 am, David N. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Hi,
> 
> I’m looking for a tools under windows that can draw a SQL map using a  
> sql file and ruby convention. So relations are kept and I can get a nice  
> gif or jpeg file  
> with my DB schema.

Well, if your DB has the foreign key constraints in it (and it should  
– check out [http://www.redhillonrails.org](http://www.redhillonrails.org) for an easy way to do  
that), then you could use a tool like Power\*Architect (  
[http://www.sqlpower.ca/page/architect](http://www.sqlpower.ca/page/architect) ) to quickly draw the ER  
diagrams.

> Thanks 🙂

## Best,

Marnen Laibow-Koser  
removed\_email\_address@domain.invalid  
[http://www.marnen.org](http://www.marnen.org)