Download and Install AdventureWorks Database

AdventureWorks Database is a sample database available online. You can use this database to practice each function that we specified in this SQL Server Tutorial. In this article, we will show you the step by step approach to Download and install the AdventureWorks Database with screenshots.

Before we start downloading and installing the AdventureWorks Database, let me show you the list of databases that are available in SQL Server.

Download and Install AdventureWorks Database 1

Download and Install AdventureWorks Database

To download AdventureWorks Database in SQL Server, please go to the Downloads page and select Adventure Works 2014 Full Database Backup.zip. If you want data warehouses, then choose & Download Adventure Works DW 2014 Full Database Backup.zip

Download and Install AdventureWorks Database 2

Click the Save button to Download AdventureWorks Database

Download and Install AdventureWorks Database 3

Once the download completed, please unzip the file. The below screenshot will show you the Unzipped file of downloaded AdventureWorks.

Download and Install AdventureWorks Database 4

Install the AdventureWorks Database in Sql Server

To install the AdventureWorks Database in SQL Server, Go to the Object Explorer. Right-click on the Databases and select the Restore Database.. option from the context menu.

Download and Install AdventureWorks Database 5

Once you select the Restore Database.. option, a new window called Restore Database will open

Download and Install AdventureWorks Database 6

Please select the Source as a device, and click …. (Browse) button

Download and Install AdventureWorks Database 7

Clicking the Browse button will open a Select backup devices window. Please click on the Add button to add or install the AdventureWorks backup file.From the below screenshot, you can see we are selecting the AdventureWorks.bak file present in the file system.

Download and Install AdventureWorks Database 8

From the below screenshot, you can see we are selecting the AdventureWorks.bak file present in the file system.

Download and Install AdventureWorks Database 9

Click Ok to close the window

Download and Install AdventureWorks Database 10

Click OK to restore the Adventure Works database.

Download and Install AdventureWorks Database 11

If everything goes well, then the following message will be displayed.

Download and Install AdventureWorks Database 12

Please refresh the SQL Server Object Explorer to see our newly installed AdventureWorks database.

Download and Install AdventureWorks Database 13

You can see the View, Stored procedures, Tables in this SQL Adventure works Database. Please explore each folder to understand the data.

Download and Install AdventureWorks Database 14

Comments are closed.