Thanks for the reminder about SQL::Translator. I added a call to "dance;" at the end to run it from the command line directly, changed the DSN etc to point at our Oracle db and I changed those "MySQL"s to "Oracle". Unfortunately, although the SQL is generated the png generation failed for me immediately with xxx:
ERROR (line 9): Invalid statement: Was expecting remark, or run, or pr
+ompt, or create, or table comment, or comment on table, or comment on
+ column, or alter, or drop
and leaving MySQL in with:
ERROR (line 789): Invalid constraint: Was expecting primary key def, o
+r unique key def, or foreign key def
The generated SQL in both cases looks ok as far as I can tell but the line number reported seems to bear no relationship to the SQL at that line number. :-(
Obviously the same happens with sqlt-graph.
BTW, I thought GraphViz was deprecated in favour of Graphviz2. |