- The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
- The Adventure Works DW database demonstrates how to build a data warehouse.
- The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
- The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.
Every new version of SQL Server should have its own AdventureWorks database. The reason is that SQL Server comes up with new features with every version and most of the new features need a new dataset sample to demonstrate the capabilities of the features. This is the why every version of SQL Server has its own AdventureWorks database.
SQL Server 2014 has many new features and to support that Microsoft has released new AdventureWorks 2014 Sample Database.
You can download Adventure Works 2014 Sample Databases from here.
Here is a quick tutorial how one can install the AdventureWorks database on your server.
Reference : Pinal Dave (https://blog.sqlauthority.com)