database - 用于 sqlserver2008 的 schemaSpy？

Question

我使用的是 sqlserver2008，这适用于 sqlserver2008 吗？？

我已经给了java -jar "D:\Program Files\SchemaSpy\schemaSpyGUI.jar"-dp "D:\jtds-1.2.5-dist\jtds-1.2.5.jar"-t mssql-jtds -db EnterpriseVaultDirectory -host localhost -端口 1433 -u sa -connprops "D:\Program Files\SchemaSpy\properties\mssql-jtds.properties"-o "D:\Schema"

还是不行...

谁能帮帮我

Answer 1

1. 请检查“D:\Program Files\SchemaSpy\schemaSpyGUI.jar”？schemaSpyGUI.jar 只是 UI 程序。你需要 schemaspy 5.0.0 ( http://sourceforge.net/projects/schemaspy/files/latest/download?source=files )并像这样使用 (java -jar "your_path\schemaSpy_5.0.0.jar"...)

2. 如果可能，请使用最新版本的 jtds(当前为 jtds-1.3.0.jar)。

3. 将“-t mssql-jtds”替换为您为系统修改“mssql-jtds.properties”的文件(我使用的是我用 mssql05-jtd.properties 编辑的 mssql05-jtds_mysystem(见下文) .所以我不使用 connprops 选项。当然 -t 选项不需要 extentname 部分(=>.properties)。

4. 你为什么不使用 Graphviz。制作简单的 ERD 图像。你必须添加 -gv 选项

   ----下面----

   # see http://schemaspy.sourceforge.net/dbtypes.html
   # for configuration / customization details
   #
   
   # Provided by Ernest Zapata, Larry Walker and Emilian Turbatu
   description=jTDS JDBC Driver for Microsoft SQL 2000/2005 Server 
   
   # majority of settings are identical to jTDS: 
   extends=mssql-jtds
   
   # return the table comments
   selectTableCommentsSql=SELECT OBJECT_NAME(t.object_id) AS TABLE_NAME, ex.value AS comments FROM ( sys.tables t LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = t.object_id AND ex.name = 'MS_Description' AND minor_id = 0) \ **--> You must change this line! you need () and no line feed'\'** 
   JOIN sys.schemas s ON t.schema_id = s.schema_id AND s.name = :schema \
   WHERE OBJECTPROPERTY(t.object_id, 'IsMsShipped')=0 \
   ORDER BY OBJECT_NAME(t.object_id)
   
   # return the column comments
   selectColumnCommentsSql=SELECT OBJECT_NAME(c.object_id) AS TABLE_NAME, c.name AS COLUMN_NAME, ex.value AS comments \
   FROM sys.columns c \
   LEFT OUTER JOIN sys.extended_properties ex \
   ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' \
   JOIN sys.tables t ON t.object_id = c.object_id \
   JOIN sys.schemas s ON t.schema_id = s.schema_id AND s.name = :schema \
   WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 \
   ORDER BY OBJECT_NAME(c.object_id), c.column_id