MsSql.Adapter.Collector
1.0.2
.NET 6.0
This package targets .NET 6.0. The package is compatible with this framework or higher.
.NET Core 3.1
This package targets .NET Core 3.1. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet tool install --global MsSql.Adapter.Collector --version 1.0.2
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.0.2
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=MsSql.Adapter.Collector&version=1.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
nuke :add-package MsSql.Adapter.Collector --version 1.0.2
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.