How to Install MS SQL Server on Mac and Create Databases – Step by Step

Channel Avatar
Comment
X
Share
How to Install MS SQL Server on Mac and Create Databases - Step by Step
How to Install MS SQL Server on Mac and Create Databases – Step by Step
This video explains step by step how to Install MS SQL Server on Mac OS and create databases.

The step are as follows:
00:00 – Introduction
00:45 – Download and Install Docker
02:20 – Download the MS SQL Server Image to Docker
03:32 – Run the Container
05:16 – Install the MS SQL CLI
06:11 – Test the Installation by Login In
06:43 – Download and install the GUI application – Azure Data Studio
08:55 – Download the BikeStores sample database
10:15 – Run the SQL Query to Create the Database objects
11:40 – Run the SQL Query to Load Data

Downlaod Docker from here – https://www.docker.com/products/docker-desktop

Downlaod Azure Data Studio from here
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?viewsql-server-ver15

Get the BikeStores Sample Datatabase here
https://www.sqlservertutorial.net/wp-content/uploads/SQL-Server-Sample-Database.zip

Command to pull MSSQL Docker Image
sudo docker pull mcr.microsoft.com/mssql/server:2019-latest

Command to run the container
docker run -d –name sql_server_demo -e ‘ACCEPT_EULAY’ -e ‘SA_PASSWORDreallyStrongPwd123’ -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest

Command for M1 Chip, please try this
docker run -e /”ACCEPT_EULA1/” -e /”MSSQL_SA_PASSWORDreallyStrongPwd123/” -e /”MSSQL_PIDDeveloper/” -e /”MSSQL_USERSA/” -p 1433:1433 -d –namesql mcr.microsoft.com/azure-sql-edge

My SQL Tutorials – www.kindsonthegenius.com/mssql

Visit www.kindsonthegenius.com
My Tech Channel https://www.youtube.com/c/KindsonTheTechPro

My websites
http://www.kindsonthegenius.com
http://www.munonye.com
http://www.datarmatics.com

Learn Programming by joining International Computer Programmers here:
https://www.facebook.com/groups/internationalcomputerprogrammers

Feel free to connect with me
️ Facebook: https://www.facebook.com/kindsonm/
️ Instagram: https://www.instagram.com/kindsonthegius
️ LinkedIn: https://www.linkedin.com/in/kindson/
️ Twitter: https://twitter.com/KindsonM
️ Pinerest: https://www.pinterest.com/kindsonm/
️ Tumblr: https://www.tumblr.com/blog/kindsonthegenius

Your support can help me improve my content:
Buy me a coffee: https://www.buymeacoffee.com/PWsXo7h13
Support me on Patreon: https://www.patreon.com/kindsonthegenius

You can find lots of MS SQL tutorials on website

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *