MsSql.Adapter.Collector
1.2.0
dotnet tool install --global MsSql.Adapter.Collector --version 1.2.0
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo dotnet tool install --local MsSql.Adapter.Collector --version 1.2.0
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=MsSql.Adapter.Collector&version=1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
nuke :add-package MsSql.Adapter.Collector --version 1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
MsSql.Adapter.Collector
This tool will collect information about all the stored procedures in a database and store the results in a result.json file.
Use the tool as a global tool
dotnet tool install -g MsSql.Adapter.Collector
mssql-adapter-collector --connection "MultipleActiveResultSets=true; Application Name=SQLCollect
or; Data Source=localhost; Initial Catalog=my_database; User ID=test; Password=test"
Use the tool as a local tool
dotnet new tool-manifest
dotnet tool install MsSql.Adapter.Collector
dotnet mssql-adapter-collector --connection "MultipleActiveResultSets=true; Application Name=SQLCollect
or; Data Source=localhost; Initial Catalog=my_database; User ID=test; Password=test"
Available options
| Command Line Argument | Environment Variable | Default Value | Description |
|---|---|---|---|
| --connection | SqlCollectorServiceOptions__ConnectionString | The database connection string. | |
| --user | SqlCollectorServiceOptions__ConnectionUser | The database connection user. | |
| --password | SqlCollectorServiceOptions__ConnectionPassword | The database connection password. | |
| --pattern | SqlCollectorServiceOptions__ProcedurePattern | (?i)(^prc__?)(?!.internal). | The pattern to use for identifying valid stored procedures. |
| --previous | SqlCollectorServiceOptions__PreviousResultFile | result_prev.json | The previous generated results, used to keep same order for members. |
| --output | SqlCollectorServiceOptions__ResultFile | result.json | The output file path relative to current working directory. |
| --skip-response | SqlCollectorServiceOptions__SkipOutputParams | false | Skip parsing response of stored procedures. |
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
| .NET Core | netcoreapp3.1 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
This package has no dependencies.