Thursday, March 22, 2012

AdventureWorks vs AdventureWorksDW

I am new to SQL Server.
There are 2 databases for AdventureWorks sample application, AdventureWorks and AdventureWorksDW.
Is the AdventureWorksDW database generated from AdventureWorks or it is design manually?
Can anyone explain to me how to produce the AdventureWorksDW database? Thanks.

You can download both databases from this link:

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

In this forum, we make use of the Adventure Works OLAP database built off the AdventureWorksDW relational database. When you download the samples from the link above, you will be given a Visual Studio solution that will build the OLAP database for you. Read the README files that come with the download for details.

Good luck,
Bryan

No comments:

Post a Comment