Download AdventureWorks sample database for SQL Server

By FoxLearn 11/13/2024 2:53:13 PM   159
These downloads include scripts and full database backups (.bak) files that allow you to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases on your SQL Server instance.

The AdventureWorks database is a sample database provided by Microsoft, designed for use with Microsoft SQL Server and other SQL Server-based tools. It simulates a fictional company called Adventure Works Cycles, which manufactures and sells bicycles and related products.

Download Install SQL Scripts

To install AdventureWorks, download the AdventureWorks-oltp-install-script.zip file, or use the files located in the oltp-install-script folder on GitHub.

To install AdventureWorksDW, download the AdventureWorksDW-data-warehouse-install-script.zip file, or use the files in the data-warehouse-install-script folder on GitHub.

Download AdventureWorks (OLTP) full database backups

AdventureWorks2022.bak

AdventureWorks2019.bak

AdventureWorks2017.bak

AdventureWorks2016.bak

AdventureWorks2016_EXT.bak

This is an extended version of AdventureWorks, designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database.

AdventureWorks2014.bak

AdventureWorks2012.bak

Download AdventureWorksLT (Lightweight) full database backups

AdventureWorksLT2022.bak

AdventureWorksLT2019.bak

AdventureWorksLT2017.bak

AdventureWorksLT2016.bak

AdventureWorksLT2014.bak

AdventureWorksLT2012.bak

Download AdventureWorksDW (Data Warehouse) full database backups

AdventureWorksDW2022.bak

AdventureWorksDW2019.bak

AdventureWorksDW2017.bak

AdventureWorksDW2016.bak

AdventureWorksDW2016_EXT.bak

An extended version of AdventureWorksDW2016 designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database.

AdventureWorksDW2014.bak

AdventureWorksDW2012.bak

Additional OLTP backups and samples

Adventure-works-2014-oltp-in-memory-sample.zip