I'm just trying out the SchemaSpy to spy on my Microsoft SQL Server DB (on Win7). What I found is that SchemaSpy is still using a very old JDBC driver.
The error I got is:
Using database properties:
Failed to load driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
These entries don't point to valid files/directories: [C:\Program Files\Microsof
t SQL Server 2000 Driver for JDBC\lib\msbase.jar, C:\Program Files\Microsoft SQL
Server 2000 Driver for JDBC\lib\mssqlserver.jar, C:\Program Files\Microsoft SQL
Server 2000 Driver for JDBC\lib\msutil.jar]
Use the -dp option to specify the location of the database
drivers for your database (usually in a .jar or .zip/.Z).
I did some googling, and found that the JDBC for SQL 2000 had those in the install package (Msbase.jar, Mssqlserver.jar, Msutil.jar), but since SQL server 2005, there have been only 1JAR file. Ref:
And also according to
Microsoft SQL Server JDBC Driver 2.0
the Installation Directory is:
%InstallationDirectory%\Microsoft SQL Server JDBC Driver\sqljdbc_<version>\<language>\
Could you double check it please?
Meanwhile, could you send me a sample of the generated .dot Graphviz file please? As complicated as possible please. It's for my personal use, and I won't redistribute it.