Download AdventureWorks sample database for SQL Server
By FoxLearn 11/13/2024 2:53:13 PM 250
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
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.
Download AdventureWorksLT (Lightweight) full database backups
Download AdventureWorksDW (Data Warehouse) full database backups
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.
Additional OLTP backups and samples
- Saving changes is not permitted in SQL Server
- How to change ‘Edit Top 200 Rows’ and ‘Select Top 1000 Rows’ in SQL
- How to fix 'The specified sa password does not meet strong password requirements'
- How to Set Up Dark Theme in SQL Server Management Studio
- DBCC CHECKIDENT RESEED 0
- How to drop temporary table if exists
- How to convert timestamp to date in SQL Server
- How to convert SQL Server's timestamp column to datetime format