How to Restore a SQL Server Database on macOS Using Docker
Channel: Christian Hur
Date: 2022-01-28

⭕ 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:
https://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: https://christianhur.com
⭕ My complete online training courses:
      ☑️ REST APIs & AJAX Operations Using Node, Express, and jQuery:  https://www.udemy.com/course/rest-apis-ajax-operations-using-node-express-and-jquery/?referralCode=A762AE70D9FD6A931F9B
      ☑️ Build Clean and Secure PHP Web Apps From Scratch:  https://www.udemy.com/course/build-clean-and-secure-php-web-apps-from-scratch/?referralCode=C200BB52F0C7153B93CC
      ☑️ Angular 9 New Features: https://www.packtpub.com/web-development/angular-9-new-features-video
      ☑️ Full-Stack Web Development with Flask: https://www.packtpub.com/web-development/full-stack-web-development-flask-video
      ☑️ Full-Stack Web Development with Django & Angular 8: https://www.packtpub.com/web-development/full-stack-web-development-with-django-and-angular-8-video
      ☑️ Angular 7 New Features:  https://www.packtpub.com/web-development/angular-7-new-features-video
      ☑️ The DOM in JavaScript, jQuery, AngularJS, and React : https://www.linkedin.com/learning/the-dom-in-javascript-jquery-angularjs-and-react
      ☑️ Building JSF Web Applications with Java EE 7:  https://www.linkedin.com/learning/building-jsf-web-applications-with-java-ee-7
      ☑️ Troubleshooting Vue.js:  https://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:  https://www.mc-store.com/collections/christian-hur/products/developing-business-applications-for-the-web-with-html-css-jsp-php-asp-net-and-javascript