This project is read-only.

Adventure Works 2014 Sample Databases

Rating:        Based on 21 ratings
Reviewed:  16 reviews
Downloads: 991991
Released: Jul 3, 2015
Updated: Nov 2, 2017 by BarbKess
Dev status: Stable Help Icon

Recommended Download

Source Code Adventure Works 2014 Full Database Backup.zip
source code, 43774K, uploaded Jul 24, 2014 - 515950 downloads

Other Available Downloads

Source Code Adventure Works 2014 OLTP Script.zip
source code, 18420K, uploaded Aug 27, 2014 - 83166 downloads
Source Code Adventure Works 2014 Warehouse Script.zip
source code, 20748K, uploaded Aug 27, 2014 - 47155 downloads
Source Code Adventure Works DW 2014 Full Database Backup.zip
source code, 21027K, uploaded Jul 29, 2014 - 103574 downloads
Documentation Readme for Adventure Works 2014 Sample Databases.docx
documentation, 31K, uploaded Jul 28, 2014 - 79033 downloads
Application Adventure Works Multidimensional Model SQL 2014 Full Database Backups.zip
application, 32378K, uploaded Jul 31, 2014 - 37997 downloads
Application AW Multidimensional Models SQL Server 2014.zip
application, 944K, uploaded Jul 24, 2014 - 25594 downloads
Documentation Readme for Adventure Works DW 2014 Multidimensional Databases.docx
documentation, 35K, uploaded Nov 11, 2016 - 25949 downloads
Documentation How to install Adventure Works 2014 Sample Databases.pdf
documentation, 323K, uploaded Jul 3, 2015 - 58096 downloads
Application Adventure Works Internet Sales Tabular Sample Database
application, 2132K, uploaded Nov 11, 2016 - 9121 downloads
Application Adventure Works Internet Sales Tabular Sample Solution
application, 76K, uploaded Nov 11, 2016 - 6356 downloads

Release Notes

AdventureWorks2014 downloads are available in the SQL Server Samples repository on GitHub .

Please update existing links to point to the GitHub release location. Downloads on this page are archived on Codeplex for your convenience only.

Release notes for downloads on this page:

This download includes Adventure Works sample databases and solutions for SQL Server, SQL Server Data Warehouse, and SQL Server Analysis Services.
  • Adventure Works 2014 sample databases are an upgrade from the 2012 versions.
  • Adventure Works 2014 sample databases also work on SQL Server 2016; however, no specific updates were made to support new features in this version.
  • Adventure Works Internet Sales Tabular sample database and sample solution are at the 1200 compatibility level and will only work on SQL Server Analysis Services 2016 or later. To create an Adventure Works Internet Sales sample solution and database at a lower compatibility level, follow steps in Analysis Services tabular modeling tutorial on MSDN. Select a lower compatibility level when creating the new project in SQL Server Data Tools.

To learn how to install the databases, see Readme for Adventure Works 2014 Sample Databases.docx.

Reviews for this release

     
Will this work for sql server 2016?
by mahmed_0429 on Jul 1, 2015 at 10:43 PM
     
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. https://www.youtube.com/watch?v=JhuDtvbpses
by junaithhaja on Sep 1, 2014 at 3:57 AM
     
Will this also work on the SQL server 2012 version??
by Avinesh_ETL on Jun 15 at 1:15 PM
     
Windows cannot open or unzip the folder. Tried for below files. 1. Adventure Works 2014 Full Database Backup 2. Adventure Works DW 2014 Full Database Backup 3. Adventure Works 2014 OLTP Script 4. Adventure Works 2014 Warehouse Script The Compressed (zipped) Folder "C:\Users\xxxxxxx\Downloads\Adventure Works DW 2014 Full Database Backup.zip" is invalid.
by ShashankV16 on Feb 22 at 9:51 AM
     
just be aware of this Adventure Works 2014 sample DB is not Adventure Works 2014 AD, usually MSDN test DB is the last one......Be careful. i know this badly......
by RainmanRay on Dec 9, 2016 at 6:47 AM
     
I tried to install this on sql 2014 and it doesn't work. The bak file was made in some other version of sql and cannot be loaded by sql 2014. The install script was made in sql 2008 and uses data types ("date") that are not supported in sql 2014. Change the datatypes to DATETIME and the script will run. Also note that the default install location of SQL Server is different than what is specified in the script.
by zephyrprime on Sep 15, 2016 at 8:40 PM
     
Where can i download a version for MS Access as *.accdb?
by trainer_schwerin on Jan 13, 2016 at 11:54 AM
     
I Got Error; Msg 3241, Level 16, State 0, Line 2 The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\AdventureWorks2014.bak' is incorrectly formed. SQL Server cannot process this media family. Msg 3013, Level 16, State 1, Line 2 RESTORE DATABASE is terminating abnormally.
by ozguracar on Dec 29, 2015 at 3:07 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, 2015 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, 2015 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, 2015 at 10:36 AM
     
buck dasn't attach
by Ss_pp on Apr 22, 2015 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, 2015 at 9:52 PM
     
All works around but I have an error: The media family is incorrectly formed...
by pop_alexandra on Mar 24, 2015 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, 2015 at 10:10 PM
     
Its Very Very Helpful ... Thanks..
by Coral_Reefs on Sep 8, 2014 at 12:58 PM