Last active
November 25, 2019 00:56
-
-
Save WadeBarnes/f2ec8ef1ebfec49d6f13f89b30ee2d2a to your computer and use it in GitHub Desktop.
SchemaSpy command line for MS SQL Database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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