AdventureWorks Sample Databases

SQL Server introduces the Adventure Works Cycles company. This company with its business scenarios, employees, and products is the basis for the following sample databases: 

  • AdventureWorks sample OLTP database

  • AdventureWorksDW sample data warehouse

  • AdventureWorksAS sample analysis services database

These databases are used in the code examples in SQL Server Books Online, and in code samples that can be downloaded from the Microsoft SQL Server Samples and Community Projects home page.


The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.

In This Section



Adventure Works Cycles Business Scenarios

Describes Adventure Works Cycles, the fictitious company on which the sample databases are based, and the business scenarios used to determine the design of the databases.

AdventureWorks Sample OLTP Database

Describes in detail the AdventureWorks sample OLTP database.

AdventureWorks Sample Data Warehouse

Describes AdventureWorksDW, the sample data warehouse used in Books Online to demonstrate the business intelligence features that are available in SQL Server.