The tool builds dependency map for particular SQL objects (tables, stored procedures etc.). It's useful especially in case of legacy systems with a lot of nested views, synonyms and compelx stored procedures.
-c, --config Required. Path to json configuration file.
-n, --names Required. Comma separated root sql objects. Provide fragment of name or full name.
-t, --types Filter for sql object type of root. Possible values: Tbl (table), Syn (synonym), Sp (stored procedure), Fun (function), V (view). All types by default.
-o, --output Required. Directory for output files.
-e, --exact Define how to search for roots. 1 means 'equals', 0 means 'contains'. 'Equals' by default.
--help Display this help screen.
{
"db": {
"sql-database-key-1": "path-to-sql-database-project-1",
...
"sql-database-key-n": "path-to-sql-database-project-n"
},
"etl": "path-to-folder-with-dtsx-files",
"csharp": "path-to-folder-with-csharp-code"
}
- run
dotnet DbDependencyBuilder.dll --config C:\pathto\search-config.json --names Person --types Tbl --output C:\output
- check generated files: tree and graph of dependencies for sample csharp project and database.