Download AdventureWorks - Microsoft sample SQL and DWH database

SQL icon baseThe AdventureWorks databases are sample databases originally published by Microsoft to show how to design a SQL Server database using SQL Server 2008. AdventureWorks is the OLTP sample, and AdventureWorksDW is the data warehouse sample. 

I am using these databases for example in my scripts. Quick download links and instructions can help, if you have not this database on your SQL server yet.

Database design has progressed since AdventureWorks was first published. For a sample database leveraging more recent features of SQL Server, see WideWorldImporters. 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. 

Download AdventureWorks

All scripts and backups are now from Microsoft on Github and you can use install script or restore backup. All instructions are on download page.

Author info
Author: Stanislav DubenWebsite:
About me
I am experienced database engineer with more than 12 years developing and optimization experience. I worked on many high level projects based on SQL servers. I am also photograper and owner of many internet projects.

Add comment

Security code