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 AW Database, let me show you the list of databases that are available in SQL Server.
Download and Install AdventureWorks Database
To download AdventureWorks Database 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. Click the Save button to Download Database.
TIP: Please refer to the installation of SQL Server and the installation of SQL Management Studio software into the local system.
Once the download is completed, please unzip the file. The below screenshot will show you the Unzipped file of downloaded AdventureWorks.
Install the AdventureWorks Database in Sql Server
To install the Database, Go to Object Explorer. Right-click on the SQL Server Databases and select the Restore Database.. option from the context menu. For more information, please visit our SQL tutorial page.
Once you select the Restore Database.. option, a new window called Restore Database will open. Please select the Source as a device, and click the …. (Browse) button.
TIP: Please refer to the create a SQL Database and restore SQL database articles.
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.
From the below screenshot, you can see we are selecting the AdventureWorks.bak file present in the file system.
Click Ok to close the window
Click OK to restore the Adventure Works database.
If everything goes well, then the following message will be displayed.
Please refresh the Object Explorer to see our newly installed database. You can see the SQL views, SQL stored procedures, and SQL tables in this Adventure Works Database. Please explore each folder to understand the data.
Comments are closed.