Get Reverse Snowflake Joins at SourceForge.net. Fast, secure and Free Open Source software downloads   
  

How to run the tool

First try the online demo

The tool it works on most platform including Mac OS X, Windows, and Linux (for example the demo site)

Next, run the GUI with

python gui.py

Generating a diagram from file:

python revj.py sample.sql

Command line parameter '-' will cause text to be read from standard input.If you paste directly text, end input with ^D (^Z on Windows)

python revj.py -

Once output is error free, feed it into Graphviz:

python revj.py - | dot -T png -o current.png

If there are too many tables, output is not so nice. Emden R. Gansner suggested to generate a graph, parse it and generate a new, directed graph which looks much better:

python revj.py - | neato | gvpr -fdir.g | dot -Grankdir=LR -Edir=none -T png -o current.png