Skip to content

Instantly share code, notes, and snippets.

@akagaeng

akagaeng/work-with-dotnet-code-and-mssql-from-mac.md

Last active May 31, 2020 07:48
Show Gist options
  • Save akagaeng/7239365730f952acee3011f07c3c1bb2 to your computer and use it in GitHub Desktop.
Save akagaeng/7239365730f952acee3011f07c3c1bb2 to your computer and use it in GitHub Desktop.
Download ZIP
MAC에서 .NET Core / MSSQL 작업하기
Raw
work-with-dotnet-code-and-mssql-from-mac.md

MAC에서 .NET Core / MSSQL 작업하기

.NET Core SDK 설치

MSSQL 설치 with Docker

MSSQL docker 이미지 다운로드

$ sudo docker pull mcr.microsoft.com/mssql/server:2017-latest

MSSQL 컨테이너 실행

  • docker run을 이용하는 방법
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pass@word' \
   -p 1433:1433 --name mssql2017 \
   -d mcr.microsoft.com/mssql/server:2017-latest
  • docker-compose를 이용하는 방법
$ docker-compose -f mssql2017.yaml up -d

MSSQL 컨테이너 종료

  • docker run으로 실행시킨 경우
$ sudo docker stop mssql2017
  • docker-compose로 실행시킨 경우
$ docker-compose -f mssql2017.yaml stop

MSSQL 컨테이너 삭제

$ sudo docker rm mssql2017

SQL Server에 연결

MSSQL Client 설치

MSSQL 접속

  • 다음과 같이 설정 후 접속
- Connection Type: Microsoft SQL Server
- Server: localhost
- Authentication type: SQL Login
- User name: SA
- Password: Pass@word

References

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment