Walkthrough: Installing the Adventure. Works Database. This walkthrough shows how to install the Adventure. Works. 20. 08 sample database on your local machine, which is a prerequisite for other walkthroughs provided in the Report.
Viewer documentation. Adventure. Works. SQL Server or SQL Server Express, but can be downloaded from Codeplex. You can use the instructions provided in this walkthrough to download, install, and configure a connection to the Adventure.
The AdventureWorksDW2008R2 sample data warehouse is used in SQL Server Books Online to demonstrate the business intelligence features that are available in SQL Server. The data in the data warehouse has been trended to support both data mining and Online Analytical Processing (OLAP) scenarios. You.
Works. 20. 08 database. Note. To successfully install the Adventure. Works. 20. 08 database, you must have installed the full- text search feature and enable FILESTREAM for your SQL Server 2. R2 instance. If you want to use SQL Server 2.
R2 Express, be sure to install the SQL Server 2. R2 Express with Advanced Services edition with the full- text search feature and with FILESTREAM enabled. You can download SQL Server 2. R2 Express with Advanced Services from the Microsoft Download Center. To learn more about using the Adventure. Works. 20. 08 sample database, you can search for "Adventure. Works Sample OLTP Database" in SQL Server Books Online.
Where to download AdventureWorks2008.msi? up vote 7 down vote favorite I'd like to install AdventureWorks2008 (I just install SQL Server 2008 R2 Express). Each time I download the recommended version from CodePlex, all I get is a AdventureWorks2008.mdf. Note: When you click the big Download button on the SQL Server R2 sample code project page (this one). Download SQL 2008 Extended Events Manager Project Site Download Allocation SQL Server Management Studio Add-in Project Site Download. The AdventureWorks2008R2 sample databases that are used in the code examples in SQL Server Books Online can be downloaded from the Microsoft SQL Server Samples and Community Projectshttp:// home page. This is a SQL Script for AdventureWorksLT 2008 Database which is provided by Microsoft. I'm providing this sql script as if somebody wants to install only AdventureWorksLT 2008 database and they don't want to download and install from a MSI or Zip.
Where to download Adventure. Works. 20. 08. msi? There isn't an . msi file for adventureworks, even though you'll find it mentioned in outdated documentation and books. You aren't alone in finding this confusing - - it seems the web site, files and steps Microsoft provides for installing these databases changes every time I need to install them. You need to create the database and attach the . In order to attach the file, you need to make sure you carefully follow the steps here: http: //social.
Readme_for_Adventure_Works_Sample_Databases. Instructions for 2. R2: To install Adventure. Works. 20. 08. R2 OLTP database. Download the Adventure. Works. 20. 08. R2 Data File.
From File Download, click Save and browse to a location on your local. From SQL Server Management Studio, execute the following code: Case- insensitive Database. CREATE DATABASE Adventure.
Works. 20. 08. R2. ON (FILENAME = '{drive}: \{file path}\Adventure. Works. 20. 08. R2_Data. FOR ATTACH_REBUILD_LOG.
As an alternative to step 3, you can attach the database using the SQL. Server Management Studio user interface.
For more detailed. Attach a Database (SQL Server Management Studio). Note: You must remove the log file from the list of files to attach. This will cause the operation to rebuild the log.
Headache saving tip from Aaron Bertrand: You should place the mdf file in your normal data folder - SQL Server. You can get this path using. SELECT TOP (1) physical_name FROM master.
Adventure Works Sample Data Warehouse. The following sections provide more information about the data warehouse itself and about the scenarios that it supports: Adventure. Works. DW2. 00. 8R2 contains a subset of the tables from the OLTP database, in addition to financial information that is pulled from a separate data source. The data is kept in synch with the OLTP database to support typical Integration Services scenarios such as loading and updating the data warehouse. The AWData. Warehouse. Refresh Package sample demonstrates how to use an Integration Services package to load data into Adventure. Works. DW2. 00. 8R2 from the Adventure.
Works. 20. 08. R2 OLTP database. Adventure. Works. DW2. 00. 8R2 contains two subject areas, finance and sales, which are described in the following sections. Additionally, the data warehouse contains views that are used to support the data mining scenarios that are described later in this topic. Finance. The finance subject area of the data warehouse is broken down into two schemas that have the following characteristics: Finance. Contains finance data for Adventure Works corporate and its subsidiaries.
Contains data in the local currency of the organization to which it is associated. Supports the Analysis Services Finance measure group. Currency Rates. Contains currency conversion data, including daily average rates and end of day rates in relationship to the United States Dollar (USD). Supports the Analysis Services Currency Rates measure group. Sales. The sales subject area is broken down into four schemas with the following characteristics: Reseller Sales. Contains sales only to resellers.
Contains only shipped orders. Contains data in USD and tracks original currency. Supports the Analysis Services Reseller Sales measure group. Sales Summary. Contains a summary view of the reseller and Internet sales data. Has reduced dimensionality compared to the reseller and Internet sales schemas.
Internet Sales. Contains individual customer Internet sales order and detail data. Contains only shipped orders. Contains data in USD and tracks original currency. Supports the Analysis Services Internet Sales measure group.
Sales Quota. Contains sales quota data for sales representatives. Supports the Analysis Services Sales Quota measure group.
The Internet sales tables have been trended to support data mining scenarios, whereas the other tables have been trended to support OLAP scenarios. Back to Top. The trending in the Adventure. Works. DW2. 00. 8R2 database supports the following data mining scenarios: Forecasting: Supports the scenario of an analyst investigating the growth of bicycle models by time and region.
Targeted Mailing Campaign: Supports the scenario of an analyst applying various data mining algorithms to Adventure Works customer and Internet sales data to determine the demographic attributes of customers who are likely to purchase a bicycle. The analyst can then apply the data mining model to a list of potential customers in order to determine which customers are most likely to respond to a targeted mailing that promotes Adventure Works bikes. Market Basket Analysis: Supports the scenario of a developer creating a market basket solution that suggests a product based on other products that already exist in a customers shopping cart. Sequence Clustering: Supports the scenario of an analyst investigating the sequence in which customers put items in a shopping cart. These scenarios and the trending in the data warehouse are demonstrated in the Data Mining Tutorial in SQL Server Books Online and in the Adventure Works DW sample project. For More Information: Basic Data Mining Tutorial.
Back to Top. The trending in the Adventure Works DW database supports the following data mining scenarios: Financial Scenarios. Financial Reporting: Supports the scenario of reporting income statements and balance sheets that include all subsidiaries. Also supports the ability to report the financial data in a specified local currency. Actual versus Budget: Supports the scenario of analyzing actual expenses against budgeted expenses. Sales Scenarios. Product Profitability Analysis: Supports the scenario of analyzing the product sales margin by tracking costs, discounts, and selling prices. Sales Force Performance: Supports the scenario of tracking the variance between sales quotas and actual sales.
Trend and Growth Analysis: Supports the scenario of analyzing how the current period compares to prior periods in terms of sales. Promotion Effectiveness: Supports the scenario of analyzing how promotions affect sales performance. These scenarios and the trending in the data warehouse are demonstrated in the Analysis Services Tutorial in SQL Server Books Online and in the Adventure. Works. DW2. 00. 8R2 sample project.