-
Notifications
You must be signed in to change notification settings - Fork 5
Home
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.
You can find installation instructions on our README.
Anonymize all text columns longer than two characters!
sqlcmdcli.exe anonymizedb {options} [flags]
sqlcmdcli.exe anondb {options} [flags]
-servername: (-s:) SQL Server instance name
-databasename: (-d:) Database name
-username: (-u:) SQL Server username
-password: (-p:) Password
-schemaname: (-schema:) The name of the table schema
-tablename: (-table:) The name of the table
-columnname: (-column:) The name of the column you want to anonymize
-help Shows help for the command
-verbose Shows details about the results of running
sqlcmdcli.exe anonymizedb -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -verbose
sqlcmdcli.exe anondb -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword
Runs a specific workload to reproduce a query's regression. It can be used to analyze the regression of a query with the SQL Server Query Store. Once the regression has been identified, it is possible to proceed with the manual forcing of the optimal execution plan!
sqlcmdcli.exe querystoreworkload {options} [flags]
sqlcmdcli.exe qsw {options} [flags]
-servername: (-s:) SQL Server instance name
-databasename: (-d:) Database name
-username: (-u:) SQL Server username
-password: (-p:) Password
-help Shows help for the command
-verbose Shows details about the results of running
-psp Activates the Parameter Sensitive Plan (PSP) Optimization workload
sqlcmdcli.exe querystoreworkload -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -psp -verbose
sqlcmdcli.exe qsw -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword
Extracts the database schema and runs a query for each table as fast as possible!
sqlcmdcli.exe stressdb {options} [flags]
sqlcmdcli.exe sdb {options} [flags]
-servername: (-s:) SQL Server instance name
-databasename: (-d:) Database name
-username: (-u:) SQL Server username
-password: (-p:) Password
-help Shows help for the command
-verbose Shows details about the results of running
sqlcmdcli.exe stressdb -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -verbose
sqlcmdcli.exe sdb -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword
It alters a column with dependencies in your SQL Server database!
sqlcmdcli.exe altercolumn {options} [flags]
sqlcmdcli.exe altercol {options} [flags]
-servername: (-s:) SQL Server instance name
-databasename: (-d:) Database name
-username: (-u:) SQL Server username
-password: (-p:) Password
-schemaname: (-schema:) The name of the table schema
-tablename: (-table:) The name of the table
-columnname: (-column:) The name of the column you want to modify
-columnrename: The new name you want to assign to the column
-datatype: (-type:) The new type you want to assign to the column
-help Shows help for the command
-verbose Shows details about the results of running
sqlcmdcli.exe altercolumn -servername:BEER -databasename:AdventureWorks2017 -username:YourUserName -password:YourPassword -schemaname:Person -tablename:Person -columnname:FirstName -datatype:nvarchar(100) -verbose
Thank you for checking out sqlcmdcli! Please open an issue to send us feedback. We're looking forward to hearing it.