Skip to content

Instantly share code, notes, and snippets.

@pedroppinheiro
Last active August 28, 2019 15:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pedroppinheiro/1e4ca26bde13e47ee4eab34ef9efed65 to your computer and use it in GitHub Desktop.
Save pedroppinheiro/1e4ca26bde13e47ee4eab34ef9efed65 to your computer and use it in GitHub Desktop.
schemaspy config and generation command
#Command: java -jar ./schemaspy-6.0.0.jar -configFile C:/Users/pedro/Desktop/schemaspy/schemaspy_config.file
# type of database. Run with -dbhelp for details
schemaspy.t=mssql08
# optional path to alternative jdbc drivers.
#schemaspy.dp=path/to/drivers
schemaspy.dp=C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssql-jdbc-7.4.1.jre8.jar # esse jar é baixado do site da microsoft
# database properties: host, port number, name user, password
schemaspy.host=localhost
schemaspy.port=1433
schemaspy.db=BASE
schemaspy.u=sa
schemaspy.p=<senha>
# output dir to save generated files
schemaspy.o=C:\Users\pedro\Desktop\schemaspy\output2
# db scheme for which generate diagrams
schemaspy.s=<SCHEMA>
# exemplo dbo
# Uncoment to generate diagrams for all schemas in database
# schemaspy.all
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment