This release contains the full database backups, scripts, and projects for AdventureWorks2014. They are for use with SQL Server 2014 and later versions. These samples are migrated from Codeplex.
For the multidimensional and tabular models, see AdventureWorks for Analysis services.
Feedback on this release: send to sqlserversamples@microsoft.com.
Release notes
- AdventureWorks2014 sample databases are an upgrade from the 2012 versions.
- AdventureWorks2014 sample databases also work on later versions; however, no specific updates were made to support new features those versions.
AdventureWorks2014 (OLTP) downloads
adventure-works-2014-oltp-full-database-backup.zip
A full database backup (.bak) of AdventureWorks2014. It is an OLTP database sample.
adventure-works-2014-oltp-script.zip
Script and source data files to build and install AdventureWorks2014.
adventure-works-2014-oltp-readme.txt
Instructions to install AdventureWorks2014 from the full database backup or with the script.
adventure-works-2014-oltp-in-memory-sample.zip
This is an in-memory sample for SQL 2014. It requires that you already have the OLTP version of AdventureWorks2014 installed.
AdventureWorksDW2014 (data warehouse) downloads
adventure-works-dw-2014-full-database-backup.zip
A full database backup (.bak) of AdventureWorksDW2014. It is a sample database for data warehousing, and provides source data for the multi-dimensional and tabular analysis projects mentioned in this release.
adventure-works-dw-2014-script.zip
Script and source data files to build and install AdventureWorksDW2014.
adventure-works-dw-2014-readme.txt
Instructions to install AdventureDWWorks2014 from the full database backup or with the script.
Downloads
- 42.7 MB adventure-works-2014-oltp-full-database-backup.zip
- 11.9 KB adventure-works-2014-oltp-in-memory-sample.zip
- 18 MB adventure-works-2014-oltp-script.zip
- 3.63 KB adventure-works-2014-readme.txt
- 20.5 MB adventure-works-dw-2014-full-database-backup.zip
- 3.58 KB adventure-works-dw-2014-readme.txt
- 20.3 MB adventure-works-dw-2014-script.zip
- Source code (zip)
- Source code (tar.gz)