AdventureWorksLT on SQL Server Express. Save the AdventureWorksLT2012_Data.mdf file to the Data folder for the SQL Server Express instance you.
Closed as off-topic by, Feb 29 '16 at 9:08 This question appears to be off-topic. The users who voted to close gave this specific reason:. 'Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, and what has been done so far to solve it.' – Raj, Ingo Karkat, Jaco, gotqn, Infinite Recursion If this question can be reworded to fit the rules in the, please.
AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from GitHub site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.
The Microsoft team keeps updating the sample database as they release new versions. Update: Please refer this blog post for the updated instructions You can download either of the data files and create a database using the same. Here is the script which demonstrates how to create sample database in SQL Server 2012.
Watch a quick video on the same subject. Every new version of SQL Server should have its own Adventure Works 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.
Please note that in SQL Server 2016 the same sample database is replaced by WideWorldImporters. You can read about that over here: This database is a replacement of old sample database called AdventureWorks (Engine version) and AdventureWorksDW (Data Warehouse version).
Reference: Pinal Dave. Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4500 articles on the database technology on his blog at a Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any send email at [email protected].
Pinal is also a. Nupur Dave is a social media enthusiast and an independent consultant.