Database Layout?

[joerg.battermann]

Hey there,

I was wondering whether any of you uses Omnigraffle to create database layouts?

Best regards,
-Joerg

[Cortig]

I have... Once or twice (it's not something I need to do every day and FileMaker/4D have rather decent way to represent database layout for my purposes).

[delu]

I tried, but it was horrible.

I used the MySQL stencils from http://www.omnigroup.com/applications/omnigraffle/extras/
but they are quite bad.
E.g. I miss a PK/FK support, like Visio has it.

Hope someone will provide a better solution, because I really like OmniGraffle.

[luftikus143]

Hi there,

any news concerning this subject? Anybody who meanwhile created and posted a stencil for database design?

Thanks for any hints!

[edwardog]

*bump*

I'm also looking for the SQL Schema Import extra which seems to have disappeared. Anyone still have it hanging around?

[JKT]

For stencils, try Graffletopia (http://graffletopia.com/)

[edwardog]

I'm actually looking for the script that'll turn SQL into an OmniGraffle diagram; anyone still have it handy?

[halbtuerke]

Does anyone have this script?

Thanks in advance

[pingu]

Did anyone manage to track this script down? If so would you mind posting up a URL?

Cheers
Dan

[fmueller]

There are scripts that generate Graphviz files (see here (http://www.graphviz.org/Resources.php)). These, in turn, can be imported in OG.

[anndr0id]

That link doesn't work - I'm trying to import a mysql file into a diagram.... anyone? Please :( This is making me want to cry!!

[DerekAsirvadem]

Sorry, I might be a bit late to the thread.

I use OG extensively for drawing my Data Models. For large assignments, of course I use heavy duty software which connects directly to the db server, but the diagrams are poor. So for many years now, for any small to medium assignment, or to elevate the quality of boring diagrams on a large assignment, I use OG. if you use the File/Export facility to produce a PDF; and the Properties/Action to JumpElsewhere in the doc, you can create quite large and complex models. Here is an example of a 4-page Data Model (http://www.softwaregems.com.au/Documents/Documentary%20Examples/Order%20DM%20Advanced.pdf), with links (click the blue glass buttons or shadowed or collapsed objects).

I do not understand why people use all sorts of different diagramming techniques with various symbols, when there is a stongly established standard, IDEF1X, which most customers want, so I draw only standard-compliant Data Models. The idea is, the diagrams are complete and convey all important info.

I developed a series of Stencils of OG, posted them at Graffletopia, and received good reports. And yes, I keep them up-to-date. Please read the intro/description on each of them (saves me typing here):

Data Model (IDEF1X) (http://graffletopia.com/stencils/588)

Entity Relation Diagram (ERD) (http://graffletopia.com/stencils/590)

Data Flow Diagram (SSADM) (http://graffletopia.com/stencils/589)

I am working on a IDEF0 (Process) stencil.