.dmg
file. Move the Docker icon into Applications folder as shown below:-e ACCEPT_EULA=Y
indicates that you agree to Microsoft’s EUA (End User Licence Agreement).-e SA_PASSWORD
is where you set the system administrator password for SQL Server. The password must be at least 8 characters long and contain characters from three of the following four sets: uppercase letters, lowercase letters, numbers & symbols.-p
flag allows the 1433 to be used as the TCP port number.--name
sets the instance name to sqlserver2019.-d
runs docker in deamon mode, used to run the container in the background.docker ps -a
sqlcmd
to connect to SQL Server on Mac. Use the following command to start an interactive shell inside your newly installed container:>1
response, which allows you to run SQL commands. Execute the following SQL commands one by one:sqlcmd
. Although the command line works well, I prefer to use a GUI-based application to manage databases. SQL Server Management Studio is my primary choice for managing databases on Windows but it comes to mac, I use SQLPro for MSSQL nowadays.