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 :
docs.microsoft.com/en-us/sql/...
Terminal Command to move Adventure Works to SQL Docker Container :
docker cp ~/Downloads/AdventureWorks2019.bak {containerID}:/var/opt/mssql/data/
**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

[@rahmiozerdemir8151]

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

[@kayjoshi350]

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

[@BruceWilliams-mt9xt]

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

[@Ola2526O]

Awesome! Many thanks. Well appreciated.

[@julybrown4916]

Thank you for such helpful and very useful video.

[@proactivegirl]

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

[@ONikeeenO]

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

[@ninalange3989]

thank u so so much!

[@yadmer100]

Thank you!! Exactly what I was looking for!

[@datawithdominic]

Happy to help

[@Hipp962]

THANK YOU SO MUCH you saved meeee 😭😭

[@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 :(

[@rudreshjasani5081]

btw thank you for the installation video

[@KennieFIRE]

Thank you a lot!

[@mert7046]

Thank you so much!

[@hamzaaltaee2895]

Thanks , keep it up

[@kametayturar]

THANK YOU!!!

[@soheilpalermo491]

Thanks mate really helpful

[@datawithdominic]

Glad it helped

[@chelseacook1854]

Thank you SO MUCH!

[@datawithdominic]

Happy to help Chelsea !

[@joscaz]

Thanks, it worked

[@omgmaw]

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

[@Bell-eg9pz]

Thank you!

[@cerioscha]

Thanks !

[@NiranjanMariyappa]

Thank you

[@uwayojacques317]

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

[@rudreshjasani5081]

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.

[@anthonyobiora1987]

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

[@user-qi2xq4rm2i]

Hi! Can you please help? I'm having an error. It says this: Restore Database: Microsoft.Data.SqlClient.SqlError: 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 :/

[@beyonder7817]

same error :(

[@G25071983]

same error

[@beyonder7817]

try downloading the 2019 version, it is showing an error for 2022 version

[@leiwu4302]

I successfully insalled Adventureworks, but when I run a select query, it is not working. Error Msg 10347 Common Language Runtime (CLR) is not enabled on this instance. Please help! Thanks!

[@keithbonaventure8302]

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

[@manansharma3889]

What does this exactly do in SQL if someone can make. me understand. I am new to SQL

[@itssaintwalrus5577]

God bless your soul

[@lana.16]

Thank you for this video. May I know how I could import a csv table into the database?

[@datawithdominic]

Will do this video soon ? Do you want it for mac or windows ?

[@lana.16]

@@datawithdominic for mac. thank you!

[@lilasle]

I use Macbook air 2019, I follow the instruction but when the restore step I couldn't find it in my Azure Studio even I press refresh many times

[@VladislavaVucetic]

go to general setting icon (for me its bottom left), then hit Command Palette and in search bar put Restore. it pulls up same box as in video and it worked for me

[@matveykokin4879]

@@VladislavaVucetic Thanks boss!

[@missloliipop]

how to input a csv file in Azure data studio with a MacBook please??

[@datawithdominic]

Thanks for the recommendation will definitely cover this in a future video

[@chijiokekelvinson6504]

Hi, in the adventureWorks.. i queried for HumanResources.Employee table but i keep getting Msg 10347 about Common Language Runtime(CLR) is not enabled on this instance.. Any way to solve this ?

[@lucaszago314]

Same here

[@schan263]

I think it's because that is a large table and azure sql edge is for small devices with little resources. I am going to switch to Azure SQL server.

[@dans4]

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

[@user-rm4sx6lm7u]

In Azure settings you should find "Workbench: Enable Previous features...". Check this box and apply to all profiles. Next in Search line enter: >restore

[@davidkim9709]

any luck? missing the restore options as well. Tried below solution, but that did not work.

[@hadiqabukhari6780]

@@davidkim9709 facing the same problem

[@schan263]

Select a database (create a dummy one if necessary) and then select "Manage". You will see the Restore option. Don't worry about different database. It will be corrected once you select the bak file. However, azure sql edge doesn't work for tables with more rows (ie. employee table), it seems. You can only query against small tables. So I am switching to Azure SQL Server.

[@Hubbs3of6]

I received an error "no such directory" and I copied directly ":/var/opt/mssql/data/". What did I do wrong?

[@brusso439]

I had the same issue. You have to remove the curly brackets between the ID.

[@Hubbs3of6]

@@brusso439 Thank you. I figured it out 3 weks ago. Much appreciated.

[@hadiqabukhari6780]

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

[@matveykokin4879]

Same... Were you able to solve the issue yet?

[@schan263]

Select a database (create a dummy one if necessary) and then select "Manage". You will see the Restore option. Don't worry about different database. It will be corrected once you select the bak file. However, azure sql edge doesn't work for tables with more rows (ie. employee table), it seems. You can only query against small tables. So I am switching to Azure SQL Server.

[@Harry96mega]

Hiii. Why I don't have the restore option?? Anybody can help me?

[@schan263]

Select a database (create a dummy one if necessary) and then select "Manage". You will see the Restore option. Don't worry about different database. It will be corrected once you select the bak file. However, azure sql edge doesn't work for tables with more rows (ie. employee table), it seems. You can only query against small tables. So I am switching to Azure SQL Server.

[@nvardbaghdasaryan9570]

Thank you, very helpfull video. Could you please advise how to enable CLR integration on Azure data studio in order to solve the problem regarding HumanResources.Employee database with the follwoing error: --Msg 10347, Level 16, State 1, Procedure Employee, Line 1 Common Language Runtime(CLR) is not enabled on this instance. Msg 474, Level 16, State 0, Line 1 Unable to load the computed column definitions for table "HumanResources.Employee".--

[@KishanPatel-te9zh]

Hi. Were you able to find a solution for this? Thanks!

[@schan263]

I think it's because the Employee table is big. Azure Sql Edge is meant for small device. So you can query small tables but not with a larger table. I am switching to Azure SQL Server.

[@user-mg1vl1yr8d]

thx you! how do I fix human.resources.employee table??

[@datawithdominic]

Can you elaborate what you want to fix exactly ?

[@mitrasinoviic]

@@datawithdominic I have the same problem. Common Language Runtime (CLR) is not enabled on this instance. Unable to load the computed column definitions for table "HumanResources.Employee".

[@G4thungu]

Hi there, did you get a FIX for this error? I have the same error

[@KishanPatel-te9zh]

@@G4thungu Hi. Did you manage to find any solution for this? Thanks :)