Assets
20
- adventure-works-2014-oltp-in-memory-sample.zip 11.9 KB
- AdventureWorks-oltp-install-script.zip 20.2 MB
- AdventureWorks2012.bak 44.9 MB
- AdventureWorks2014.bak 44.6 MB
- AdventureWorks2016.bak 46.5 MB
- AdventureWorks2016_EXT.bak 125 MB
- AdventureWorks2017.bak 48 MB
- AdventureWorksDW-data-warehouse-install-script.zip 23.2 MB
- AdventureWorksDW2012.bak 21.8 MB
- AdventureWorksDW2014.bak 21.4 MB
- AdventureWorksDW2016.bak 21.4 MB
- AdventureWorksDW2016_EXT.bak 883 MB
- AdventureWorksDW2017.bak 22.4 MB
- AdventureWorksLT2012.bak 13.4 MB
- AdventureWorksLT2014.bak 13.3 MB
- AdventureWorksLT2016.bak 7.11 MB
- AdventureWorksLT2017.bak 7.11 MB
- sql-server-2016-samples.zip 6.37 MB
- Source code (zip)
- Source code (tar.gz)
These downloads are scripts and full database backups (.bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases to your SQL Server instance.
Note that AdventureWorks has not seen any significant changes since the 2012 version. The only differences between the various versions of AdventureWorks are the name of the database and the database compatibility level.
For additional guidance, please review the instructions for attaching a database and restoring a database.
-
For a sample database leveraging more recent features of SQL Server, see WideWorldImporters.
-
For install instructions, see the Readme.
-
For the multidimensional and tabular models, see AdventureWorks for Analysis services. Use AdventureWorksDW as source data.
-
For more downloads of older releases, see AdventureWorks2012 and AdventureWorks2008r2.
-
Send feedback to: sqlserversamples@microsoft.com.
Install scripts
For AdventureWorks, download AdventureWorks-oltp-install-script.zip, or use the files in the oltp-install-script folder in GitHub.
For AdventureWorksDW, download AdventureWorksDW-data-warehouse-install-script.zip, or use the files in the data-warehouse-install-script folder in GitHub.
AdventureWorks (OLTP) full database backups
AdventureWorks2016_EXT.bak
Download size is 883 MB. This is an extended version of AdventureWorks, designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database.
AdventureWorksLT (Lightweight) full database backups
AdventureWorksDW (Data Warehouse) full database backups
AdventureWorksDW2016_EXT.bak
An extended version of AdventureWorksDW2016 designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on this database.