How to Install Adventure Works Database on Mac M1 & M2 | SQL Server, Docker and Azure Data Studio

How to Install Adventure Works Database on Mac M1 & M2
SQL Server Management Studio Alternate using Docker SQL Container and Azure Data Studio.

Link to the Adventure Works Download :

Terminal Command to move Adventure Works to SQL Docker Container :

**Replace container ID and the curly braces with container ID from docker application. Also make sure File name matches the download.

Keywords :
Install Adventure Works on Mac 2022
Install Adventure Works Sample Database to SQL Server Management Studio
Adventure Works Sample Database 2019
Adventureworks
SQL Studio
SQL Server Management Studio

#sqlserver #sqlservermanagementstudio #mac

[JeannePaulineMallari]

Hi! Can you please help? I'm having an error. It says this:
Restore Database: The database was backed up on a server running database version 957. That version is incompatible with this server, which supports version 931. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Is there a way to fix this or the database itself is outdated? I perfectly followed your instructions. It works on the old 2019 BAK file but not the Adventureworks 2022 which I need :/

[VladislavaVucetic]

i also dont have Restore option available. I already have enabled preview features and also installed sql server dacpac so really not sure how to get that button :(

[kayjoshi]

Thank you, great video and super easy to understand compared to any other video I watched!

[BruceWilliams-mtxt]

Super Helpful! More videos are needed! Great job!
😀

[yadmer]

Thank you!! Exactly what I was looking for!

[ItsNick-bb]

hey can anyone help. getting an error which says
Restore Database: The database was backed up on a server running database version 957. That version is incompatible with this server, which supports version 931. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
working on 2019 bak file but not on 2022 bak file.

[julybrown]

Thank you for such helpful and very useful video.

[rudreshjasani]

Hi there, right click is not working for me to manage the database on left hand side bar. can you please mention how I can do that or share me the link of the solution.

[OlaO]

Awesome! Many thanks. Well appreciated.

[rahmiozerdemir]

If RESTORE button not visible you may go to left bottom and click settings> click Command palette and write manually `restore`

[anthonyobiora]

Hello I did everything you said but my azure is not connecting ( the network related or instance -specific error occurred) please help me

[uwayojacques]

thanks for knowledge share however i am getting You must enable preview features in order to use restore

[omgmaw]

Great video. Please make more videos on azure data studios!

[Serial_Slices_]

Ohh, you are so amazing, thank you for this video!🙏

[hadiqabukhari]

There is no "restore" button showing on my Azure Data Studio when I go to "Manage"

[proactivegirl]

thank you so much! with your help only I can install MS SQL and database

[rudreshjasani]

btw thank you for the installation video

[keithbonaventure]

What happen if the restored database failed due to version? What can I do?

[dans]

Thank you for the video. Why is the "restore" option missing in Azure when I go to manage the server? There is "new database" in its place

[Dr_Pib]

This solution doesn't work for Adventure Works anymore. Azure cannot handle CLR. I've tried MANY solutions to attempt to install CLI and such, but no luck. DO NOT WASTE YOUR TIME if you want to use Adventure Works.