Sign inSign up

fagneftr/sqlcmd_cyberlab

By fagneftr

•Updated 7 months ago

Docker container to run sqlcmd and bcp CLI to interact with SQL Servers Database

Image
Security
Developer tools
Databases & storage
0

590

fagneftr/sqlcmd_cyberlab repository overview

⁠Quick Start

docker run --rm -it fagneftr/sqlcmd_cyberlab:latest
⁠Interacting with MSSQL Databases

⁠Use the -v option to create bind mounts that map host directories to the container
docker run --rm -v /tmp:/tmp/ -it fagneftr/sqlcmd_cyberlab:latest

⁠GitHub Repository KeystoneDevBr/sqlcmd_cyberlab⁠

⁠Cyber Labs Tricks

⁠SQL Server Query

sqlcmd -S tcp:<IP_HOST>,<PORT> \
   -U users  \
   -P password \
   -d database \
   -C

Note In some cases, you can use alias to improve your SQL Server queries

# Creating Alias: 
alias sql='docker run --rm -it \
	-v /tmp:/tmp/ \
	fagneftr/sqlcmd_cyberlab:latest \
	sqlcmd -S tcp:<IP_HOST>,<PORT> \
	-U SA  \
	-P Senha@Forte \
	-d Database \
	-C -Q'


# Using The Alias:
query "SELECT name FROM sys.databases;"

⁠Query Result Export

bcp "SELECT name FROM sys.databases;" queryout /tmp/databases.csv \
  -S "tcp:<IP_HOST>,<PORT>;Encrypt=yes;TrustServerCertificate=yes" \
  -U SA \
  -P Senha@Forte \
  -d Database \
  -t";" \
  -c

Tag summary

Content type

Image

Digest

sha256:bde44feeb…

Size

35.7 MB

Last updated

7 months ago

docker pull fagneftr/sqlcmd_cyberlab