SQL Server Samples Portal Page > SQL Server Sample Databases

Sample Databases

SQL Server 2008R2 product sample databases are now available.

SQL Azure sample databases are now available.

SQL Server 2008 product sample databases are still available. If you are having difficulties with the SQL Server 2008 installer, please see Database Installer Help.

SQL Server 2005 product sample databases are still available.

Got questions? Want to contribute? Check out the SQL Server Community & Samples Discussion Forum!

This site is dedicated to the several sample databases that ship for Microsoft SQL Server. 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, PDF and PNG 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 locate the schema diagrams here.


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


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


There are multiple releases of the sample databases. The release labeled SQL Server 2005 SP2a contains installers which will work for SQL Server 2005. The current release (currently labeled SQL Server 2008R2 RTM) contains two families of sample databases -- AdventureWorks and AdventureWorks2008R2. The AdventureWorks family is schema compatible with the sample databases for SQL Server 2005. The AdventureWorks2008R2 family has breaking schema changes in order to support some new scenarios and demonstrate new features in SQL Server 2008R2. The samples databases from SQL Server 2008R2 RTM will not install correctly on SQL Server 2005. Please use the installers in the SQL Server 2005 SP2a release for that.

For step by step instructions on how to configure the prequisites that are needed before you can install the sample databases for SQL Server 2008R2 see Database Prerequisites. For step by step installation instructions on how to install all the sample databases for SQL Server 2008, see Installing Databases.

The AdventureWorks2008R2 family of sample databases are described below.
All databases use the default server collation.
AdventureWorks 2008R2 Family
Sample database with "2008R2" in their name are part of the AdventureWorks 2008R2 sample database family.

The AdventureWorks 2008R2 family of databases demonstrates some of the new features of SQL Server 2008R2. This family of databases can only be used with SQL Server 2008 and SQL Server 2008R2 and will not install successfully for earlier versions of SQL Server. The table below lists the sample databases in this family:

Database Name Description Details
AdventureWorks2008R2 The new OLTP database designed for SQL Server 2008R2 Details
AdventureWorksDW2008R2 The new data warehouse designed for SQL Server 2008R2 Details
AdventureWorksAS2008R2 The new analysis services database designed for SQL Server 2008R2 Available now
AdventureWorksLT2008R2 The new light version of the OLTP database for SQL Server 2008R2 Available now

We recommend that samples, books, and other training material which was originally targeted for SQL Server 2005 or earlier be updated to use the AdventureWorks 2008R2 family of databases within the next two years. Support for the AdventureWorks family of sample databases will end when the next major release after SQL Server 2008R2 ships.

Last edited Nov 8, 2010 at 7:39 PM by bonniefe, version 50