How to Install Adventure Works Database on Mac M1 & M2 | SQL Server, Docker and Azure Data Studio
Вставка
- Опубліковано 19 вер 2024
- 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...
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
If RESTORE button not visible you may go to left bottom and click settings> click Command palette and write manually `restore`
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 :(
Thank you!! Exactly what I was looking for!
Happy to help
Thank you, great video and super easy to understand compared to any other video I watched!
Super Helpful! More videos are needed! Great job!
😀
Awesome! Many thanks. Well appreciated.
Thank you for such helpful and very useful video.
Thanks mate really helpful
Glad it helped
Great video. Please make more videos on azure data studios!
thank you so much! with your help only I can install MS SQL and database
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 :/
same error :(
same error
try downloading the 2019 version, it is showing an error for 2022 version
Thank you SO MUCH!
Happy to help Chelsea !
Ohh, you are so amazing, thank you for this video!🙏
Thank you a lot!
btw thank you for the installation video
Thanks, it worked
THANK YOU SO MUCH you saved meeee 😭😭
THANK YOU!!!
Thanks , keep it up
thank u so so much!
Thank you
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
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
@@VladislavaVucetic Thanks boss!
thanks for knowledge share however i am getting You must enable preview features in order to use restore
Thanks !
God bless your soul
There is no "restore" button showing on my Azure Data Studio when I go to "Manage"
Same... Were you able to solve the issue yet?
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.
Thank you for this video. May I know how I could import a csv table into the database?
Will do this video soon ? Do you want it for mac or windows ?
@@datawithdominic for mac. thank you!
Hello I did everything you said but my azure is not connecting ( the network related or instance -specific error occurred) please help me
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.
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!
how to input a csv file in Azure data studio with a MacBook please??
Thanks for the recommendation will definitely cover this in a future video
Hiii. Why I don't have the restore option?? Anybody can help me?
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.
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
In Azure settings you should find "Workbench: Enable Previous features...". Check this box and apply to all profiles. Next in Search line enter: >restore
any luck? missing the restore options as well. Tried below solution, but that did not work.
@@davidkim9709 facing the same problem
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.
What does this exactly do in SQL if someone can make. me understand. I am new to SQL
What happen if the restored database failed due to version? What can I do?
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 ?
Same here
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.
I received an error "no such directory" and I copied directly ":/var/opt/mssql/data/". What did I do wrong?
I had the same issue. You have to remove the curly brackets between the ID.
@@brusso439 Thank you. I figured it out 3 weks ago. Much appreciated.
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".--
Hi. Were you able to find a solution for this? Thanks!
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.
thx you! how do I fix human.resources.employee table??
Can you elaborate what you want to fix exactly ?
@@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".
Hi there, did you get a FIX for this error? I have the same error
@@G4thungu Hi. Did you manage to find any solution for this? Thanks :)
Thank you so much!
Thank you!