Skip to content

Build dependency map for particular SQL objects (tables, stored procedures etc.)

Notifications You must be signed in to change notification settings

MaximTkachenko/legacy-db-dependency-builder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

50 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

legacy-db-dependency-builder

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.
  1. import database schema to sql project
  2. prepare json config in the following format (sample):
{
	"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"
}
  1. run
dotnet DbDependencyBuilder.dll --config C:\pathto\search-config.json --names Person --types Tbl --output C:\output
  1. check generated files: tree and graph of dependencies for sample csharp project and database.

About

Build dependency map for particular SQL objects (tables, stored procedures etc.)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published