search

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.62k stars 200 forks source link

SQL Server using -schemas is not finding any tables? #18

Closed l8nite closed 8 years ago

l8nite commented 8 years ago

I have a sql server instance with a schema named 'foo'.

The user I'm using to connect has a default schema set to 'foo' and has grants set up which restricts its access to the foo schema only.

I'm trying to generate a graphviz diagram of all the tables contained in that schema:

./schemacrawler.sh -server=sqlserver -host=localhost -database=C -schemas=C.foo -user=FooUser -password=FooPassword -infolevel=maximum -command=graph -outputformat=pdf -outputfile=schema.pdf

This ends up empty... am I doing something obviously wrong here?

l8nite commented 8 years ago

Nevermind, this was user error - I was running against the wrong database :ghost: