Schemaspy export?

Question

I'm searching a way to draw a diagram for the complex database of my project. I found schemaspy by the question here, and it fits my need except for one thing: my database is quite complex so that it made a lot of arrow intersections, which make it hard for reading. And the export file is html, so that I can't drag-drop to relocate the tables.

Overall this is a useful tool, but I'm wondering if I can export the diagram to a popular format for other programs to read? Maybe MS Visio, Pencil or another diagram-prototype tool? I have searched on Schemaspy website but found nothing related to it.

score 2 · Accepted Answer · answered Sep 19 '12 at 20:21

SchemaCrawler is a free command-line tool that diagrams databases. SchemaCrawler is particularly useful when diagramming large and complex schemas, since it can diagram tables based on regular expression searches. In your case, you can consider have not a single database diagram, but multiple ones, one for each business domain in your system.

For example, you could have one diagram for customer related tables, another for accounts and still another for sales. Some tables could be common between them. With SchemaCrawler, you can easily say that you are interested in all tables with a column called CUSTOMER_ID, and parent and child tables down to 2 levels.

SchemaCrawler outputs diagrams in GraphViz DOT format for use in other diagramming tools, as well as any other format supported by GraphViz, such as PDF or PNG.

Sualeh Fatehi, SchemaCrawler

Hi Sualeh, do SchemaCrawler has the ability to export the "object relation model"? — Hoàng Long, Nov 01 '12 at 08:21
Hoàng, SchemaCrawler only looks at the database, and so cannot infer object relationships. — Sualeh Fatehi, Nov 01 '12 at 14:30
thanks for your information. Actually I'm trying to find someway to really drag-n-drop the table. I will give SchemaCrawler a try though — Hoàng Long, Nov 02 '12 at 16:37

Schemaspy export?

1 Answers1