
The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios: The AdventureWorks OData service exposes resources based on specific SQL views. This should make it easier to find and download AdventureWorks databases since all OLTP versions are on one page.
Each zip file contains an mdf database file and ldf log file. This release consolidates AdventureWorks databases for SQL Server 2012, 2008R versions to one page. This should make it easier to find and download AdventureWorks databases since all OLTP Click the OK button on the Attach Databases dialog window to attach the database.įrom SQL Server Management Studio, execute the following code:.
Click the OK button on the Locate Database Files dialog window. For instance, AdventureWorks2012_Data.mdf. Locate the AdventureWorks database mdf file. From Microsoft SQL Server Management Studio, connect to a SQL Server instance. Unzip the database (mdf) file and log (ldf) file. Download a database for your SQL Server version. The light-weight version is denoted by the LT abbreviation in the filename.Įach zip file contains the database (mdf) file and log (ldf) file for AdventureWorks 2012, 2008R.Īn AdventureWorks database can be installed by attaching the database, or using the CREATE DATABASE statement. For each release of the product, there is a light-weight and full version of the AdventureWorks sample database.