How to download and import AdventureWorks sample database for Microsoft SQL Server 2019

In this tutorial, I will show you where to download the AdventureWorks sample database and import the database to your Microsoft SQL Server 2019 database system (or any version of Microsoft SQL Server database).
What is AdventureWorks database?
AdventureWorks database is a sample for an online transaction processing (OLTP) database provided by Microsoft.
Link to Microsoft AdventureWorks sample database download page
github.com/Microsoft/sql-serv...
In case if you forgot how to install Microsoft SQL Server database and SQL Server Management Studio (SSMS)
• How to download and in...
📺 How To Build A MS SQL Server SQL Query Tool Using Excel: • Building A MS SQL Serv...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood.com/jiej6
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → / madeinpython
📘 More tutorial videos on my website → LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [e-mail]
#AdventureWorks #AdventureWorksDatabase

[@ruckus181]

You deserve way more subs and recognition. You are truly a wonderful teacher! Thank you so much Jie Jenn!

[@Macspt]

Instructions worked perfectly, and helped me setup a test MS-SQL_Express_2019 instance in a Windows-10 VM.

[@GorgoniteScum]

Another Great Vid! I've just discovered your channel and I'm looking forward to working through the SQL Tutorials, Phython & the API Tutorials.

[@catg4417]

Couldn't have loaded this without this video !! Thank You!!!

[@maxuk4894]

Clear step by step explanation. Thanks for uploading!

[@michaelangelothomas8397]

It was a great tutorial.
It will be even greater if a tutorial is created to add also Northwind and Pubs sample databases,
because most of the older books use these sample databases

[@melr4353]

Thank you for this video! Very clear and detailed :)

[@vanste9876]

thank you so much, clear explanation with no useless info, props to you and happy new year as well :D

[@jonathancerdajuarez6937]

I found your video and got it solved!!! Thanks a lot!!! brief and clear!!

[@lohitshandilya2390]

Thanks mate, coffee is on your way.

[@jiejenn]

Glad my video helped. And thanks for the coffee!

[@affanrafiquemirza]

Thanks a lot dude. deserves a like and share. Keep working hard and helping others

[@josearielperaltalara4355]

Thank you. It really helped me a lot.

[@antonisxoustoul8719]

Wow.!! Thank you for uploading this explanatory video.

[@serenawisnewskiherter2255]

I love you! you saved my ass for a school assignment! such a helpful and clear tutorial!!

[@karenjang5201]

Appreciate for the simple and accurate video

[@ruth8850]

Thank you very much! Super Helpful! :)

[@dishabajaj4614]

It was very helpful and easily understandable. Thanks a lot

[@arsaurabh6044]

Excellent Tutorial. Installed AdventureWorks DB. Works perfectly. Thanks

[@jiejenn]

Glad the video helped.

[@ibrahimwahab9801]

Thank you, Jie. It helps

[@cliffinkaemurd1320]

Thanks man keep up the good work

[@owowaolumide1525]

Thank you! It was so helpful

[@dbldbl_anmlstyle895]

Appreciate the help man!

[@kg2474]

Sir you saved me!!!!!! I was five minutes away from throwing this laptop out the window. Thank you so much!!!

[@jiejenn]

Glad the video helped.

[@Tfal.]

youtube is a magic place, u saved me man thank u !

[@roberttorres345]

Thank you so much....That was very helpful!

[@MrTeebaba]

Thank you so much for this video!

[@ajibolaojo]

Extremely useful.. thank you so much... worked for the Adeventureworks2019

[@AdrianAcostaPR]

Thank you for this. It is very detailed and straight forward!!!

[@jiejenn]

Glad my video helped.

[@yadullahkurt2189]

you deserve to be a king.

[@nnenne4]

Thank you, that really helped me

[@ImranAmiKh4n]

Thank you - the clearest instructions I have come across

[@jiejenn]

Glad the video helped.

[@abrarfahad]

Hi Jai Jen,
Thank you for your video for importing the SqlServer 2017 database. It is very easy to understand.
I have a SqlServer 2014 database. I want to upgrade to SqlServer 2019. Is there are any extra steps to import database backup file to SqlServer 2019?

[@KA-id7ve]

Great explanation thank you!

[@ellenmaearticona8743]

Thank you very much for the clear presentation 👍🏻

[@jiejenn]

Glad my video helped.

[@mohammadsi678]

Nice explanation, a great help, thank you so much.

[@joannesasil8465]

Thank you so much for this vid. It helped me a lot.

[@kramchancel1266]

THANK YOU SOOOOOOO MUCH!!!! My Professor told us to download with this without providing any instructions.

[@jiejenn]

Glad the video helped. So winter break is over?

[@SakethRamKayam]

Super awesome. This is really helpful

[@billlong9313]

Helpful! Thank you!

[@jecelynbelegorio7606]

So helpful to us students. Thank you very much!

[@jiejenn]

Glad the video helped.

[@jennyggf3556]

Tnx for the video, it helped a lot

[@susmithareddy8202]

It's really very helpful thank you so much 😍

[@paulina6335]

thanks a lot! I was struggling with that

[@jiejenn]

Glad my video helped.

[@kingkunta8353]

thank you so much for this. it really helped me in a lot of ways

[@Desi_american]

Thank you.. very simple way of exolaining.. it helped

[@hudoyberdirahimov748]

Thanks for your help man. :D

[@singum3615]

Thank you. Very helpful

[@jiejenn]

Glad my video helped.

[@ajitkumar15]

Thank you very much, it is a very good and helpful video on importing AdventureWorks sample database

[@BillsMafia3]

Thank you! This was great!

[@jiejenn]

Glad the video helped.

[@amlankiranpatel9753]

thank you for the information.

[@ramessurhusanand9931]

hi when
grateful if you can advise me when I am downloading database file from adventureworks it opens in R studio . How can I stop it from opening in R studio.

[@aungyethu9743]

Thanks a lot for your great effort

[@waleedmemon9215]

thanks alot .. it was very helpful

[@sagararavalli7366]

Thank you very much, it was very helpful.

[@jiejenn]

Glad the video help.

[@JimRohn-u8c]

Thank you so much!

[@crystalhowison6150]

Thank you so much for this!

[@jiejenn]

Glad the video helped.

[@jemuelrivera9281]

Thank youuu. ❤️

[@pratikmoharana4275]

it was a very helpful and informative video. Thank you

[@jiejenn]

Glad the video help.

[@sudarshanm5994]

Thanks man❤

[@alvarovasquez8588]

Very good video!!

[@lakshmisowbhagya8944]

thank you for sharing the video

[@areejahmad4732]

How do I download SQL 2014 on MAC and Adventureworks .

[@shikharewa]

Thank you:)

[@mycaribeat]

Thanks!

[@user-cz4eg1od2p]

thank you very much!

[@obalions]

This is a very helpful video, thank you so much @Jie Jenn

[@drawshjassim3094]

Thank you.

[@Charlie_Stuffs]

Ty bro!

[@Eva-km3ig]

Thank you!

[@jiejenn]

Glad the video helped.

[@zorrobasher2947]

ThankYou Bro

[@ilhametgar7378]

Thank you!!

[@ahinsa__parmo__dharam]

Thanks alot sir 🙏

[@ejpeninger]

Thank You!!

[@fernandoarce804]

Great!

[@adityachary2478]

thank you bro

[@martineavila5708]

thanks. very good.

[@anuragbawankar685]

Thanks a lot !!!

[@sureshparvathini1421]

Thanks so much.

[@valeripetrov8889]

Thanks ! :)

[@sarthak810]

Thanks a lot

[@kalpeshpande637]

Thank you..!

[@jiejenn]

Glad the video helped.

[@showyou1197]

its just awesome

[@jiejenn]

Glad the video helped.

[@thilaksalian9509]

Thank you

[@arunchenchu]

Thanks mate

[@ButFirstCoffee539]

why the backup folder is not opening for me ..pls anyone can suggest ...

[@jeansteveetienne4461]

thank you!

[@paulamartey4936]

Awesome

[@molitatube]

thank you

[@LuisPerez-ce7fn]

thankss!

[@sunnydj484]

Thank you,Gracias ,Merci , Grazie , Danke , Bedankt

[@jacobli2676]

Hi, thanks for your tutorial. Currently I am having troubles opening the backup folder, I clicked on it, and I just could not go into it. Anyone knows why?

[@jiejenn]

Makes sure you have admin right to the backup folder.

[@jacobli2676]

@@jiejenn Thanks, I re-installed the SQL Server, and right now it is working well.

[@ilyeseljawhari4969]

i can't open backup folder

[@Endou77]

THank ouuuuuu

[@chuyjfc]

Thanks

[@kurtmendieta5879]

good

[@carchis]

How do I add this database to report builder?

[@jiejenn]

I don't use report builder so can't help you on this one unfortunately.

[@carchis]

@@jiejenn thanks

[@rafidalani1146]

Thank you