Functionality

Current Functionality

Functionality mirroring SQLCMD behavior:

• -U "User ID" (if not present then -E / trusted_connection is used)
• -P "Password"
• -S "Server"
• -d "Database name"
• -H "Workstation name"
• -Q "Query"
• -l "Login (i.e. connection) timeout" (default: "15")
• -t "Query (i.e. command) timeout" (default: "30")
• -K "Application intent"
• -N Encrypt Connection (default: false)
• -C Trust Server Certificate (default: false)
• -M MultiSubnet Failover (default: false)
• -o "Output file"
• -s "Column separator" (default: " ")
• -a "packet size" (range: 512 - 32767; default: "4096" {default for .NET SqlConnection = "8000"!})
• -u encode output file as "Unicode" (UTF-16 Little Endian)
• -i "Input file[,input file2...]"
• -c "Batch terminator" (default: "GO")
• -? / -help / (no command-line options) Display usage

Functionality unique to SimpleSqlExec:

• -ad "Attach DB filename"
• -an "Application name" (default: "Simple SQL Exec")
• -cs "Connection string"
• -ra "Rows Affected file path or User environment variable name"
• -mf "Messages file"
• -oh "Output file handling" (OverWrite, Append, or Error)
• -debug "Debug info file"

Near-Term Functionality

Functionality mirroring SQLCMD behavior:

• -b Batch Abort
• -f codepage | i:codepage[,o:codepage] | o:codepage[,i:codepage] Input / Output file code pages
• -A DAC connection

Functionality unique to SimpleSqlExec:

• -ef "Error File"

Backlog

• SQLCMD commands (e.g. :r to read in a file)
  • -X[1] Disables "ED" and "!!" SQLCMD commands
• Passing in variables (-v option for SQLCMD)
• -x ignore scripting variables
• -h headers
• -m error_level
• -V error_severity_level
• -p[1]
• ?? -r[0 | 1] Redirects the error message output
• ?? -R
• ?? -e Writes input scripts to stdout