New Row

The other day I ran into issues with Schema Spy pointing it to a database with 1.200 tables for the first time. The problem The error output was the following: Writing/diagramming detailsINFO – Completed summary in 277 seconds INFO – Writing/diagramming details .Exception in thread “main” java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119) at java.base/java.lang.reflect.Method.invoke(Method.java:578) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52) Caused by: org.schemaspy.output.diagram.RenderException: Failed to generate Table diagram at org.schemaspy.output.diagram.TableDiagram.generateTableDiagram(TableDiagram.java:24) at org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateRealTableDiagrams(MustacheTableDiagramFactory.java:93) at org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:57) at org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:488) at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:289) at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:135) at…

Read More Read More

Meet Extended Properties Microsoft introduced Extended Properties in order to document SQL Server Objects. Take a close look…there’s a plural “s” at the end. This allows great flexibility for you to come up with your own extended properties. But there’s a downside to documenting your custom properties: It is time consuming. You would either have to script them all…which is a bit clumsy with all this levelxtype and levelxname. Alternatively set out on a journey with clicking through a lot…

Read More Read More

SchemaSpy is a great free open source software for database documentation. You can get a first glimpse of this awesome tool by viewing the sample output. This blog post shows how to configure SchemaSpy to connect to a database using integrated authentication with MS AD  (your windows login) in a Windows environment. Please follow the steps outlined in my previous blog post to setup SchemaSpy. I would also recommend testing to connect with a SQL username and password first in…

Read More Read More

SchemaSpy is a great free open source software for database documentation. You can get a first glimpse of this awesome tool by viewing the sample output. This blog post shows how to get SchemaSpy up and running in a new Windows environment and how to document your SQL Server databases.       (to execute a class) … If “command not found” is returned or similar error messages adding java to the path didn’t work Here’s an example…you will have to change…

Read More Read More