adventureworks 2008 db

Question

Hi

I can't find on the web adventureworks 2008 sample, i find only for r2 and when i install it i have all the db but adventureworks2008 is not present.On my book that I bought 70-432 exam i have this info:

SQL Server 2008 does not ship with any sample databases. You need to download the

1.

 

Open Internet Explorer and go to http://www.codeplex.com/MSFTDBProdSamples. Click the Releases tab.

2.

 

Scroll to the bottom of the page and download the AdventureWorks2008*.msi file to your local machine

on the link I can find the release tab can you help me and give me the correct link to download sample adventureworks2008 so I can prepare me for the exam with the lab on the book.

Thanks a lot any help will be usefull

Answer 1

I am having the same problem. I have downloaded the R2, but then get stuck. I am trying to go through the book MICROSOFT SQL SERVER 2008 STEP by STEP and it gives identical directions as Model Office.

Advice is appreciated!

Thanks,
Christina

Answer 2

Your right, the link to the AdventureWorks2008 download does go to the AdventureWorks2008R2 page.  I'll check with the samples team to see if that's their intention.

However, there's really no need to download that database if you already have the R2 version.  The only thing that changed in that database (other than the database name) is the value of the datetime columns.  These values were increased by 4 years.  All of the table, column, etc. names remain the same.   So all the code examples in your books will work just fine with the R2 database.  If the examples happen to reference any datetime columns, the data will be slightly different.  The following queries will return the equivalent rows. Notice that the only change was to the value of the year in the WHERE clause.

USE AdventureWorks2008R2;
Go
SELECT BusinessEntityID, JobTitle, HireDate
FROM HumanResources.Employee
WHERE HireDate >= '20001231';

USE AdventureWorks2008;
Go
SELECT BusinessEntityID, JobTitle, HireDate
FROM HumanResources.Employee
WHERE HireDate >= '19961231';

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 3

Check this out. It points to both the SQL 2008 and SQL 2008 R2 versions of AdventureWorks.

http://willmtz.blogspot.com/2011/09/where-to-download-northwind-databases.html

Answer 4

 

 

I'm working on the 70-433 exam and I need to have the AdventureWorks2008, AdventureWorksDW2008 & Northwind databases, I have the last two 

but I can't find AdventureWorks2008.  Downloaded "AdventureWorks2008R2_SR1.exe" from codeplex but this does *not* contain this database.  See screenshot.  Anyone tell me where I can get this missing database? 

Answer 5

me 2, i have installed adventureworks2008r2_sr1, but the tables of mine is not consistent with the official one,such as there is no table "Person.person", so i find it's not the the correct one.

Answer 6

If you have not met all of the prerequisites required for AdventureWorks2008, then the installation code will not install that database.  Notice in the screenshot above, that the install package is providing the reason why the database will not be installed "Filestream is not enabled."  This is one of the prerequisites.   You can find the complete list of requirements here: http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2.

You have 2 options.  Review the prerequisites list and after following those instructions, run the adventureworks2008r2_sr1 program again.  Or, you can attach a slightly modified version of AdventureWorks2008 database from here:  http://msftdbprodsamples.codeplex.com/releases/view/59211.  This version does not require filestream to be enabled.

Regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 7

Did you successfully installed advworks2008?

Answer 8

Yes, you can get it from codeplex but you must enable filestream