I have hound many threads talking about issues with MySQL not showing relationships, but I am having the same issue with a MSSQL 2005 database. For reference, I am woefully inexperienced with SQL, so please don't assume I have overlooked anything simple.
I am attempting to run SchemaSpy against a database that is made up of 312 tables. The database is running in MSSQL05, but I believe was originally created in MSSQL 2k,. I am using SchemaSpy GUI, and am connecting with the jtds driver. I have not been able to connect with the MS JDBC driver because of a supposed port issue, which may or may not be related to this.
During the process, I do get one error: "Failed to retrieve table/view comments: java.sql.SQLexception: The multi-part identifier "ex.value" could not be bound." I do not know what this means, and searching for this didn't get me anywhere either.
Thanks in advance for any help.
I have found*
don't assume I haven't overlooked anything simple.*
Apparently at 1am I forget to proofread.