Download an AdventureWorks OLTP database

SQL2012 SQL2012.DW SQLAzure
SQL2008 SQL2008.DW Feedback2

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 locate the schema diagrams here.

Last edited Mar 24, 2012 at 12:55 AM by DerrickVMSFT, version 8


No comments yet.