Saturday , September 21 2019
Home / DataBase / SQL SERVER / SqlServer-AdventureWorks OLTP and Data Warehouse Database collections (2016,2017,2014,2012,2008)

SqlServer-AdventureWorks OLTP and Data Warehouse Database collections (2016,2017,2014,2012,2008)

What is AdventureWorks Database:

Whenever we want to do something in sql server then we requires a database, so we have to spend a lot of time to create the tables and test data before we practice sql quiries.

So Microsoft created a long time ago the fictitious multinational manufacturing company called Adventure Works and shipped the AdventureWorks database as part of SQL Server.this database contains  nearly 20,000 customers, over 70,000 orders and 500 products there is enough data for your examples. 

AdventureWorks database have 2 types

  1. OLTP Database
  2. Data Warehouse database

 1.OLTP downloads

Direct links to the OLTP versions of AdventureWorks can be found below:

Sno Download Link
1 Sql Server-2017
2 Sql Server-2016
3 Sql Server-2014
4 Sql Server-2012
5 Sql Server-2008R2

2.Data Warehouse downloads

Direct links to the Data Warehouse versions of AdventureWorks can be found below:

Sno Download Link
1 Sql Server-2017
2 Sql Server-2016
3 Sql Server-2014
4 Sql Server-2012

 

Conclusion:

We hope you find this article is helpful,  I hope you liked the article. Please share your valuable suggestions and feedback in the comments.



Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

Locked Tables

How to find locked tables in sql server

In multiuser environments, sql server ensures the integrity of the data by setting write locks …