Skip to content

Instantly share code, notes, and snippets.

@WadeBarnes
Last active November 25, 2019 00:56
Show Gist options
  • Save WadeBarnes/f2ec8ef1ebfec49d6f13f89b30ee2d2a to your computer and use it in GitHub Desktop.
Save WadeBarnes/f2ec8ef1ebfec49d6f13f89b30ee2d2a to your computer and use it in GitHub Desktop.
SchemaSpy command line for MS SQL Database
# Dependancies:
# - Java
# - sqljdbc42.jar downloaded to local directory; http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
# - Graphviz; https://www.graphviz.org/download/
# - use `-vizjs` in place of installing Graphviz; very slow and creates a larger output then Graphviz set to `-lq`
# - use `-hq` and `-lq` to control image quality
java -jar schemaspy-6.1.0.jar -lq -degree 1 -t mssql05 -host <host> -db <database> -o outDir -u <username> -p <password> -dp ./sqljdbc42.jar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment