How to Restore a SQL Server Database on macOS Using Docker

⭕ Overview
In this video, I'm thrilled to show you how to set up a SQL Server instance on your Mac using Docker, an invaluable skill for developers who need a flexible and powerful database environment for testing and development purposes.
We'll start by installing Docker if it's not already set up on your Mac, followed by downloading and configuring a SQL Server container. Once our SQL Server is up and running, I'll guide you through connecting to it using SQL Operations Studio, an intuitive tool for database management.
Next, we'll attach a sample database, Adventure Works 2016, to our SQL Server instance to demonstrate how you can begin working with real data. I'll also cover how to manage this setup effectively, including tips on restarting and maintaining your SQL Server instance within Docker.
This tutorial is perfect for developers who want to leverage SQL Server's capabilities on a non-Windows platform, enhancing your development flexibility and providing a robust environment for your database needs.
If you find this video helpful, please give it a thumbs up, share it with your friends, and subscribe to my channel for more tutorials and insights into programming. Your support helps me create more content to assist you in your learning journey. Thank you for watching!
🟩 Notes in the video here:
docs.google.com/document/d/1GB04ONXc_kC-cgmjT_GWl2Qb2TuLKmBoOSbBHfCeY1Q/edit?usp=sharing
🟩 Command to create SQL instance:
docker run -e ACCEPT_EULA=Y -e SA_PASSWORD=StrongPa$$word123 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest
🟩 Command to copy AdventureWorks2016.bak to docker container:
docker cp ~/Downloads/AdventureWorks2016.bak CONTAINER_ID:/var/opt/mssql/data/
🔸🔸🔸where CONTAINER_ID is the docker container id for the sql server instance.
⭕ Chapters
0:00 - Introduction
⭕ About me
I am a Web instructor and author for Linkedin Learning (formerly Lynda.com), Packt, E-C Council, Udemy, and MC Press.
⭕ Visit my site: christianhur.com
⭕ My complete online training courses:
☑️ REST APIs & AJAX Operations Using Node, Express, and jQuery: www.udemy.com/course/rest-apis-ajax-operations-using-node-express-and-jquery/?referralCode=A762AE70D9FD6A931F9B
☑️ Build Clean and Secure PHP Web Apps From Scratch: www.udemy.com/course/build-clean-and-secure-php-web-apps-from-scratch/?referralCode=C200BB52F0C7153B93CC
☑️ Angular 9 New Features: www.packtpub.com/web-development/angular-9-new-features-video
☑️ Full-Stack Web Development with Flask: www.packtpub.com/web-development/full-stack-web-development-flask-video
☑️ Full-Stack Web Development with Django & Angular 8: www.packtpub.com/web-development/full-stack-web-development-with-django-and-angular-8-video
☑️ Angular 7 New Features: www.packtpub.com/web-development/angular-7-new-features-video
☑️ The DOM in JavaScript, jQuery, AngularJS, and React : www.linkedin.com/learning/the-dom-in-javascript-jquery-angularjs-and-react
☑️ Building JSF Web Applications with Java EE 7: www.linkedin.com/learning/building-jsf-web-applications-with-java-ee-7
☑️ Troubleshooting Vue.js: www.packtpub.com/application-development/troubleshooting-vuejs-video
⭕ Check out my book:
Developing Business Applications for the Web: With HTML, CSS, JSP, PHP, ASP.NET, and JavaScript is available on Amazon and MC Press.
☑️ Link: www.mc-store.com/collections/christian-hur/products/developing-business-applications-for-the-web-with-html-css-jsp-php-asp-net-and-javascript

[@dionysoscurryjr]

Throwing error message when entering command in terminal. Any reason I am seeing this?

[@aishausman1575]

Thank you so much for making this video! loading the .bak file into the docker sql instance was very tricky but your step by step guide on how to do it really saved me a lot of trouble!

[@ChristianHur]

You’re most welcome! Glad to hear it was helpful. Thank you for watching and sharing your experience. All the best.

[@henrytipantuna2037]

Thank you very much friend, I have been looking for this for days and you teach it in a great way

[@ChristianHur]

Glad you found it helpful. Good luck. Best.

[@fenmora6574]

Thx! Awesome.

[@ChristianHur]

You're welcome. Good luck. :)

[@InterlinkTest1]

For some reason when I go to select the file I'm getting a access denied error. Any idea how to get around this?

[@ChristianHur]

Hmmm...could it be user access privileges set on your Mac? You might want to check that.