SQL Server Samples Portal Page > SQL Server Sample Databases

To download the sample databases click on the Releases tab or click here. Note that the default release is for SQL Server 2008. Select the SQL Server 2005 SP2a release before downloading if you are using SQL Server 2005 or the installation will fail.

Do you have questions or problems concerning CodePlex? See our FAQ.

Project Description

This project contains Database samples released with Microsoft SQL Server product.

Sample Databases

Microsoft SQL Server ships with several sample databases. You can find installers containing the sample databases on the Releases tab. You can find scripts which were used to build the databases on the Source Code tab along with Visio and JPEG versions of the schema diagrams.

Most sample databases and sample database business scenarios are documented on MSDN.

The following sample databases are currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
  • The AdventureWorks OLTP database supports standard online transaction processing scenarios for a ficticious 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.

The Adventure Works LT Database is documented here.

You can view the schema diagrams without downloading them here.

There are a new family of AdventureWorks sample databases specifically designed for SQL Server 2008. More information about these sample databases are located on the Releases tab.

Please let us know in the developer forum for this project on the Discussions tab if you would like to contribute sample databases.

Last edited Feb 27, 2008 at 7:40 PM by bonniefe, version 19