install Docker
use docker to install SQL Server(for mac intel chip)
1 | $ sudo docker pull mcr.microsoft.com/mssql/server:2023-latest |
Note : You can change the version you want by change the year of latest version
launch SQL Server image in docker
1 | $ docker run -d --name sql_server_test -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=password' -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest |
Note :
- Docker command Line - Cli
install mssql cli
1 | $ npm i -g sql-cli |
Note : mssql-cli
use mssql-cli to test whether MSSQL install success
1 | $ mssql -u sa -p password |
download GUI for MSSQL - Azure Data Studio
MSSQL connection in Node.js
Github an example of MSSQL connection
Note : Make sure server is running in Docker containers