This is the Adventure Works DW 2008R2.abf file that was downloaded earlier.įor “Restore target" - "Restore database", specify a name.įor example, call it “AdventureWorksDW2008R2”.ĩ. Specify the path and file name of the AdventureWorks cube that you want to restore. The result is that the "Restore Database" screen is shown. Right-click “Databases” and click “Restore”. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. The result is that "Microsoft Analysis Services" on localhost is connected to.ĥ. Definition AdventureWorks Database By Mark Fontecchio AdventureWorks Database is a Microsoft product sample for an online transaction processing ( OLTP) database. In Microsoft SQL Server Management Studio, click "Connect Object Explorer". Put it in, for example, location "C:\AdventureWorks Databases\2008R2".ģ. The result is that a file called “Adventure Works DW 2008R2.abf” is downloaded. Choose the “AdventureWorksDA2008R2 cube for SSAS 2008 R2”. The Microsoft team keeps updating the sample database as they release new versions. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005. Click on “SQL Server 2008 R2 OLTP” and you will be directed to the Downloads page for SQL Server 2008 R2. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from github site.
#WHAT IS ADVENTUREWORKS DATABASE INSTALL#
Install the sample AdventureWorks cube onto SQL Server 2008 R2 Analysis Services Follow these steps:ġ. Go to the following CodePlex download page:Ģ. Now the AdventureWorksDW database is attached. Remove the “AdventureWorksDW2008R2_Log.ldf” file by clicking the “Remove” button.ġ2. Click "Add" and select the “AdventureWorksLT2008R2_Data.mdf” database.ġ0. Right-click "Databases and click "Attach".Ĩ. Given privacy, security, ethics etc prevent me from parting with a genuine database and creating mock/random data is time consuming I was faced with an issue. Launch Microsoft SQL Server Management Studio and select "Server Type" = "Database Engine".ħ. Adventureworks Database Diagram This release uses the AdventureWorks2008R2 and AdventureWorksDW2008R2 sample databases. Copy the “AdventureWorksDW2008R2_Data.mdf” file to the Microsoft SQL Server DATA folder as follows:Ĭ:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATAĥ. Go to the following CodePlex download page:Ģ. Click on “SQL Server 2008 R2 OLTP” and you will be directed to the Downloads page for SQL Server 2008 R2.ģ. Click on the “AdventureWorksDW2008R2 Data File” so that the “AdventureWorksDW2008R2_Data.mdf” file is downloaded.Ĥ. Walkthrough: Installing the AdventureWorks DatabaseĪ summary of what needs to be done is as follows: Install the sample AdventureWorks database onto SQL Server 2008 R2 Follow these steps:ġ.
#WHAT IS ADVENTUREWORKS DATABASE HOW TO#
The purpose of this page is to describe where to obtain the sample Adventureworks database and multidimensional database (cube) as well as describe the process of bringing them into SQL Server 2008.Ī walkthrough that shows how to install the AdventureWorks 2008 database can be seen at the following Microsoft site:
0 kommentar(er)
