MSSQL 2005 Database not Showing Relationships

Help
Charlie W.
2012-09-27
2013-05-29
  • Charlie W.
    Charlie W.
    2012-09-27

    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.

     
  • Charlie W.
    Charlie W.
    2012-09-27

    I have found*

    don't assume I haven't overlooked anything simple.*

    Apparently at 1am I forget to proofread.