@barbkess barbkess released this Dec 12, 2017 · 240 commits to master since this release

Assets 20

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.

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

AdventureWorks2017.bak

AdventureWorks2016.bak

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.

AdventureWorks2014.bak

AdventureWorks2012.bak

AdventureWorksLT (Lightweight) full database backups

AdventureWorksLT2017.bak

AdventureWorksLT2016.bak

AdventureWorksLT2014.bak

AdventureWorksLT2012.bak

AdventureWorksDW (Data Warehouse) full database backups

AdventureWorksDW2017.bak

AdventureWorksDW2016.bak

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.

AdventureWorksDW2014.bak

AdventureWorksDW2012.bak

Additional OLTP backups and samples

adventure-works-2014-oltp-in-memory-sample.zip