SDP 7.0.0 - Dumping your schema
This is a quick overview for dumping your DB schema into a browsable format that graphically shows table relationships, fields, etc. Great for troubleshooting SDP, or for creating a complex query report. Gems like the asset owner history, status history, etc. become apparent as reporting options.
Here is the command line for windows with a MySQL DB:
Start browsing from index.html
I hope someone finds this as useful as I did. Enjoy!
Kirk.
These commands give usage for SchemaSpy:
-
1.) Install Java
2.) Download the SchemaSpy jar file, schemaSpy_3.1.1.jar, from sourceforge.
3.) Download the appropriate DB driver JDBC interface. For MySQL you need mysql-connector-java-3.1.14-bin.jar from MySQL.
4.) Install GraphViz, a free graphing visualization tool at graphviz.org.
5.) Place the jar files together in a directory.
6.) Create a subdirectory called output.
7.) Run schema spy.
8.) Wait...
Here is the command line for windows with a MySQL DB:
java -jar schemaSpy_3.1.1.jar -cp mysql-connector-java-3.1.14-bin.jar -t mysql -db servicedesk -u root -host localhost:33366
Start browsing from index.html
I hope someone finds this as useful as I did. Enjoy!
Kirk.
These commands give usage for SchemaSpy:
java -jar schemaSpy_3.1.1.jar -help
java -jar schemaSpy_3.1.1.jar -dbhelp