Download an AdventureWorks OLTP database

AdventureWorks OLTP database for SQL Server 2012 AdventureWorks DW database for SQL Server 2012 SQL Azure
AdventureWorks OLTP database for SQL Server 2008 R2 AdventureWorks DW database for SQL Server 2008 R2 Feedback

Note You can download the OLTP LT version by clicking the SQL Server 2012 OLTP tile.

  • The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
  • The Adventure Works DW database demonstrates how to build a data warehouse.
  • The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
  • The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.

You can download the schema diagrams here.

Last edited Mar 24, 2012 at 4:03 AM by DerrickVMSFT, version 14


No comments yet.