-
Would this be significantly smaller than the compact view that only shows primary keys and indexes?
Note that you should be able to write a simple script that removes all entries that aren't the table name from the relationships .dot file. Currently the only differentiation is that the table name comes first and has a (default) color of #9bab96.
Then recreate the .png with
dot...
2010-01-06 16:18:43 UTC in SchemaSpy
-
It's open source, so you can do whatever needs to be done.
2009-12-28 16:22:42 UTC in SchemaSpy
-
Initially I had all of the options listed with -help. That quickly became impossible to deal with and to keep in sync with what the web site had.
The -noads option was explicitly not documented because I didn't want people to disable ads. However I plan on removing the ads completely in the future. They've resulted in barely $10 over the past couple of years. In other words: including...
2009-12-24 00:07:46 UTC in SchemaSpy
-
I don't think it'd be able to determine an implied relationship for your example. How would it know which was the implied foreign key?
John.
2009-11-30 19:54:47 UTC in SchemaSpy
-
SchemaSpy can determine implied relationships if the column name and type match the column name and type of another table's primary key. The beta also supports Ruby on Rails naming conventions for determining implied relationships.
An alternative approach would be to use the -meta option to explicitly specify table relationships.
John.
2009-11-30 02:28:54 UTC in SchemaSpy
-
If you have two tables with the same name that only differ in their case then there's not a lot I can do to help. It would require a significant amount of work to modify the code's behavior based on whether the database preserves and honors case sensitivity. Those implications permeate down through the various file systems as well as into Graphviz.
2009-11-16 17:21:25 UTC in SchemaSpy
-
Try this google query:
http://www.google.com/search?source=ig&hl=en&rlz=&=&q=%22libocijdbc10.jnilib%3A+no+suitable+image+found%22&aq=f&oq=&aqi=
It points to a Chinese page whose translation implies that you're using a 32bit client with a 64bit server. Could that be the case?
John.
2009-11-13 00:14:13 UTC in SchemaSpy
-
johncurrier committed revision 558 to the SchemaSpy SVN repository, changing 2 files.
2009-11-12 17:49:02 UTC in SchemaSpy
-
Can you try the .properties file I attached and let me know if it works? It's your changes, but extends the default db2.properties so identical settings aren't duplicated.
Thanks,
John.
2009-11-12 17:18:03 UTC in SchemaSpy
-
I assume there are clues in this text:
/Users/oracle/product/10.2.0/db_1/lib/libocijdbc10.jnilib: no suitable image found. Did find:
/Users/oracle/product/10.2.0/db_1/lib/libocijdbc10.jnilib: mach-o, but wrong architecture
Hopefully you know what architecture mis-match is occurring (I don't). If not I'll have a Mac friend that used to work at Oracle see if he knows what's up.
2009-11-09 17:10:06 UTC in SchemaSpy
