SQLCMD command from Alpine containner

Twenty Four O Clock

·

Follow

Nov 2, 2020

--

Listen

Share

### access inside containner
kubectl exec -it po/hellospring-deployment-796cc7cb8b-7cn5d bin/bash -n bo
### Connect
sqlcmd -S bo-test.xxxxxx.co.th,1433 -d dbname -U username
Password: <enter passpord>
### list current dbname
1> select name from sys.databases
2> go
### list tableName on current dbname
1> select name from sys.tables
2> go
### switch to dbname
1> use dbname
2> go
### exit sqlcmd
1> exit