개발용 로컬 mssql for linux docker container 띄우기

셋팅

docker-compose.yml

version: '3.4'
 
services:
mssql:
image: mcr.microsoft.com/mssql/server:latest
environment:
- ACCEPT_EULA=Y
- MSSQL_PID=Developer
- SA_PASSWORD=sa@dpsekfrh.zja
volumes:
- dbdata:/var/opt/mssql
ports:
- "1433:1433"
 
volumes:
dbdata:

docker 컨테이너 띄우기

터미널에서 아래 명령 실행

$ docker-compose up
$ docker-compose ps

접속

TablePlus 에서 sa 로 접속

host: localhost

mssql 로그인 계정 생성, 권한 부여

use endalgo;
 
CREATE LOGIN endalgo WITH PASSWORD=N'dpsekfrh-Passw0rd';
CREATE USER endalgo FOR LOGIN endalgo;
ALTER ROLE db_owner ADD MEMBER endalgo;

생성한 로그인 계정으로 mssql cmd 접속해보기

터미널에서 아래 명령 실행

$ docker-compose exec mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U endalgo -P 'dpsekfrh-Passw0rd'
 
1> use mydb
2> go
Changed database context to 'mydb'
1> exit