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".Ĩ. Launch Microsoft SQL Server Management Studio and select "Server Type" = "Database Engine".ħ.
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:ġ.
#How to import adventureworks database intomysql 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)
