Usando o SchemaCrawler com o SQL2008.
1. Esquema da tabela de vendas
schemacrawler.cmd -server=sqlserver -host=192.40.40.12 -port=57285 -database=afserp -schemas=abc.dbo* -user=sameer -password=12345 -infolevel=standard -routines= -tables=.*\$Sales.* -parents=1 -children=1 -only-matching -command=schema -outputformat=pdf outputfile=relno.pdf
2. Com relacionamento
schemacrawler.cmd -server=sqlserver -host=192.40.40.12 -port=57285 -database=afserp -schemas=AFSERP\..* -user=sameer -password=12345 -infolevel=maximum -routines= -tabletypes=TABLE -grepcolumns=.*.No_ -parents=1 -children=1 -only-matching -command=schema -outputformat=pdf outputfile=relno.pdf
Eu não entendo porque ambos os comandos mostram apenas estrutura de tabela em vez de relacionamento.
Se eu usar -command=graph
, haverá erro
Output format not supported for command
Tags command-line database