Install Docker, SQL Server, Azure Data Studio on MAC Made with Clipchamp

Install SQL Server on Mac using Docker
Install Docker Desktop (if you don’t already have it)
Download: https://www.docker.com/products/docker-desktop
Install and make sure it’s running.
Pull the SQL Server image (Linux-based) using
docker pull mcr.microsoft.com/azure-sql-edge:latest
Create a docker volume
docker volume create sqledge-data
Run SQL Server container
docker run -d \
--name sqledge \
-e 'ACCEPT_EULA=1' \
-e 'MSSQL_SA_PASSWORD=YourStrongPassw0rd' \
-p 1433:1433 \
-v sqledge-data:/var/opt/mssql \
mcr.microsoft.com/azure-sql-edge:latest
Notes:
SA_PASSWORD must be at least 8 characters with uppercase, lowercase, number, and symbol.

Port 1433 is the default SQL Server port.
5. Check if it’s running
docker ps
docker logs -f sqledge

Here’s how you can install Azure Data Studio on a Mac with an M1 (Apple Silicon) chip:

1. Download the correct version
Go to the official download page:
https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Under macOS, download Azure Data Studio for Apple Silicon (.zip) — this is the ARM build for M1/M2 Macs.

2. Connect to Azure Data Studio.

Open ADS → New Connection.

Fill in:

Server: localhost (or localhost,11433 if you remapped the port)

Authentication type: SQL Login
User name: SA
Password: YourStrong!Passw0rd

Click Advanced…:

If you get encryption errors, set Encrypt = True and Trust Server Certificate = True.

Click Connect.

Azure Data Studio doesn’t always show the “Import Data” option like SQL Server Management Studio (SSMS) does but you can import data into your new database this way

Use Azure Data Studio’s “Extensions”
In ADS, click View → Extensions.

Search for SQL Server Import.

Install "SQL Server Import" (Flat File Import Wizard).

Once installed, right-click your database and choose Import Wizard.

Видео Install Docker, SQL Server, Azure Data Studio on MAC Made with Clipchamp канала Olamide Durodola ~ Opportunities Corner.