Skip to content

Readme.md

Latest commit

 

History

History
44 lines (36 loc) · 1.78 KB

Readme.md

File metadata and controls

44 lines (36 loc) · 1.78 KB

Simple Sql Connection Checker

Simplest tool to check connectivity to MS SQL Server instance.

Docker Pulls Docker Automated build Docker Build Status

Constantly checks connectivity to SQL Server each minute and writes OK/NOT OK in the output or file.
Built on .net core, so could be run on win / linux / mac.

How to run

Just run SqlConnChecker(-.exe) as binary file.

Settings

  • ConnectionString (string) - SQL connection string.
  • CheckIntervalMs (int) - how often tool shouldcheck connection (6000 ms by default).
  • VerboseOutput (bool) - show error message in output in case of connection is NOT OK (true by default).
  • WriteToFile (bool) - write or not messages to the file.
  • FileOutputPath (string) - path to the file.

How to change settings

  • modify appsettings.json:

How to build & publish:

  1. Install .Net Core 2.2 SDK or latest from the Microsoft official site
  2. Go to src folder and run
dotnet publish -c Release -r linux-x64

All supported platforms (win8, debian, ubuntu, etc.) could be found here

Docker

How to run

docker run -v /opt:/opt dmitrydoc/sqlconnchecker 
	--ConnectionString="connection string" 
	--CheckIntervalMs=1000 
	--VerboseOutput=true 
	--WriteToFile=true 
	--FileOutputPath=/opt/logs

How to build your own

docker build -t sqlchecker .