Adventure Works 2014 Sample Databases

Rating:        Based on 13 ratings
Reviewed:  10 reviews
Downloads: 394898
Released: Jul 3, 2015
Updated: Jul 3, 2015 by DerrickVMSFT
Dev status: Stable Help Icon

Recommended Download

Source Code Adventure Works 2014 Full Database
source code, 43774K, uploaded Jul 24, 2014 - 178480 downloads

Other Available Downloads

Source Code Adventure Works 2014 OLTP
source code, 18420K, uploaded Aug 27, 2014 - 33094 downloads
Source Code Adventure Works 2014 Warehouse
source code, 20748K, uploaded Aug 27, 2014 - 19317 downloads
Source Code Adventure Works DW 2014 Full Database
source code, 21027K, uploaded Jul 29, 2014 - 37790 downloads
Documentation Readme for Adventure Works 2014 Sample Databases.docx
documentation, 31K, uploaded Jul 28, 2014 - 40960 downloads
Application Adventure Works DW Tabular Model SQL Server
application, 227K, uploaded Jul 24, 2014 - 12222 downloads
Application Adventure Works Internet Sales Tabular Model 2014
application, 2809K, uploaded Jul 24, 2014 - 8468 downloads
Application Adventure Works Internet Sales Tabular Model
application, 105K, uploaded Jul 24, 2014 - 7796 downloads
Application Adventure Works Multidimensional Model SQL 2014 Full Database
application, 32378K, uploaded Jul 31, 2014 - 14100 downloads
Application Adventure Works Tabular Model SQL 2014
application, 9767K, uploaded Jul 28, 2014 - 7866 downloads
Application AW Multidimensional Models SQL Server
application, 944K, uploaded Jul 24, 2014 - 10567 downloads
Documentation Readme for Adventure Works DW 2014 Multidimensional Databases.docx
documentation, 45K, uploaded Jul 28, 2014 - 12295 downloads
Documentation How to install Adventure Works 2014 Sample Databases.pdf
documentation, 323K, uploaded Jul 3 - 11943 downloads

Release Notes

Adventure Works 2014 sample databases are an upgrade from the 2012 version. To learn how to install the databases, see Readme for Adventure Works 2014 Sample Databases.docx.

Reviews for this release

Was waiting for it since May, Adventure works 2014 has really met my expectations and found it helpful for my classes.Microsoft has made the installation process very simple than its 2012 version. Here is a video link for its installation if you have any doubts.
by junaithhaja on Sep 1, 2014 at 3:57 AM
Will this work for sql server 2016?
by mahmed_0429 on Jul 1 at 10:43 PM
For anyone with the message "The media family on device 'blah' is incorrectly formed", the most likely reason is that you're trying to restore a SQL Server 2014 database backup onto an earlier version of SQL Server. Whilst backups are forwardly compatible (which is a good thing), by the nature of development, there's no guarantee that data structures will be backwardly compatible with older versions. Try finding a version of AW that's compatible with your version of SQL Server, or restore it on SQL Server 2014.
by JonReade on Jul 15 at 10:01 AM
AdventureWorksDW database, SSAS Enterprise project, and Internet Sales Tabular project all work fine. I'm using these to test some Business Intelligence stuff so it would help to have the ETL processes for loading the DW database and maybe even some SSRS reports.
by Tatsu on Jun 9 at 2:56 PM
couldn't figure out how to install it - facing this error: The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\AdventureWorks2014.bak' is incorrectly formed
by mbrembati on May 28 at 10:36 AM
buck dasn't attach
by Ss_pp on Apr 22 at 9:56 AM
It doesn't restore : after selecting the .bak file the info message states that there are no files selected.
by marisk on Apr 15 at 9:52 PM
All works around but I have an error: The media family is incorrectly formed...
by pop_alexandra on Mar 24 at 2:47 PM
Junaith Haja's video was excellent. Be sure to download the release notes which contains the query script he references in his presentation.
by aklong99 on Jan 16 at 10:10 PM
Its Very Very Helpful ... Thanks..
by Coral_Reefs on Sep 8, 2014 at 12:58 PM