AdventureWorksDW Databases – 2012, 2008R2 and 2008

Rating:        Based on 6 ratings
Reviewed:  3 reviews
Downloads: 248914
Released: Apr 30, 2013
Updated: Oct 19, 2017 by BarbKess
Dev status: Stable Help Icon

Recommended Download

Application AdventureWorksDW for SQL Server 2012
application, 39041K, uploaded Apr 30, 2013 - 96389 downloads

Other Available Downloads

Application AdventureWorksDW for SQL Server 2008 R2
application, 9917K, uploaded Apr 30, 2013 - 103109 downloads
Application AdventureWorksDW for SQL Server 2008
application, 10267K, uploaded Apr 30, 2013 - 49416 downloads

Release Notes

AdventureWorks has moved to the SQL Server Samples repository on GitHub.

* AdventureWorks2012 on GitHub
* AdventureWorks2008r2 and 2008 on GitHub

Please update existing links to point to the new location. Downloads on this page are still available on CodePlex for your convenience. These are duplicates of the downloads on GitHub.

Release notes for downloads on this page:

This release consolidates AdventureWorksDW databases for SQL Server 2012, 2008R2 and 2008 versions to one page. Each zip file contains an mdf database file and an ldf log file. This should make it easier to find and download AdventureWorksDW databases since all OLAP versions are on one page.

An AdventureWorksDW database can be installed by attaching the database, or using the CREATE DATABASE statement.

To attach an AdventureWorks database
  1. Download a database for your SQL Server version.
  2. Unzip the database (mdf) file and log (ldf) file.
  3. From Microsoft SQL Server Management Studio, connect to a SQL Server instance.
  4. Right click Databases.
  5. Click Attach.
  6. Click the Add button.
  7. Locate the AdventureWorksDW database mdf file. For instance, AdventureWorksDW2012_Data.mdf.
  8. Click the OK button on the Locate Database Files dialog window.
  9. Click the OK button on the Attach Databases dialog window to attach the database.
From SQL Server Management Studio, execute the following T-SQL:

Example T-SQL
CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'M:\Data\AdventureWorksDW2012_Data.mdf'), (FILENAME = 'L:\Tlogs\AdventureWorksDW2012_Log.ldf') FOR ATTACH;

Reviews for this release

Both are sample database to learn about SSAS. AdventureWorks is sample DB for OLTP like how the ERP system stores the company business data. AdventureWorks represents a database of the normalized approach. AdventureWorksDW represents a database of the dimensional approach. AdventureWorksDW (DW=Data Warehouse) is datawarehouse DB that shows how a datawarehouse db designed based on the source db AdventureWorks.
by jinaldesailive on Feb 5, 2014 at 4:47 PM
very user friendly, many databases to choose from
by JSmith7 on Jun 22 at 5:15 AM
What is the difference between "AdventureWorksDW Databases – 2012, 2008R2 and 2008" and "AdventureWorks Databases – 2012, 2008R2 and 2008" ???!!! EDIT : AdventureWorksDW Dose not work for me....
by Pedram_mrn on Jul 13, 2013 at 7:52 PM