README

sqlcmdcli

sqlcmdcli utility is a command-line utility for ad hoc, interactive execution of commands on SQL Server to simulate specific workloads, anonymize sensitive data and much more.

sqlcmdcli is written in Delphi RAD Studio and lets you connect to a SQL Server instance and run specific commands. It was born in July of 2021 during a case study on queries regression in production environments using SQL Server Query Store.

Installation

sqlcmdcli uses VSoft.CommandLineParser by VSoftTechnologies, the Simple Command Line Options Parser spawned from the DUnitX Project.

The utility uses both ADO and FireDAC queries to execute Transact-SQL batches.

Available commands

The commands and related documentation are described in the sqlcmdcli wiki.