#177 Parameter ahic does not work when Parameter -all is specified on SQL Server

[Martin Guth]

Hi,

we are trying to use SchemaSpy to document our Microsoft SQL Server 2008/2014 databases. As we are using multiple Extended Properties for documentation (like author, creationDate, description) we extended the properties file to generate a html table for all comments on one column.

We call SchemaSpy with the following on command line:
C:\Users\db-mg>java -jar C:\Documentation\SchemaSpySoftware\schemaSpy_5.0.0.jar
-dp C:\Documentation\SchemaSpySoftware\jtds-1.3.0.jar -host xyz -port 1
433 -db basis -u abc -p def -t C:\Documentation\SchemaSpySoftware\3CDBB
I.properties -o C:\tableDocumentation\bi -ahic -hq -all -schemaSpec "^(?!(sys)|(
INFORMATION_SCHEMA))[a-zA-Z0-9.?!%, ]+$"

Being called with parameter -all the -ahic option seems to have no effect. The output contains the HTML sourcecode as text.

However if we use the parameter -s to specify one schema, parameter -ahic works as expected.
As we have multiple schemas schemaSpy is currently not of much use for us as it ignores the -ahic parameter.

Martin Guth