Looking for a copy of AdventureWorks2008

Question

Hi Everyone,

I've recently started to study the book 'Pro Entity Framework 4.0' from Apress, which requires that the database 'Adventureworks2008' to run the sample code.  The book gave a link to this database, but when I entered it into the browser, the page no longer existed and I was redirected to another page on the site (Codeplex).  This page had a download named 'AdventureWorks2008_sr4.exe', which I downloaded and installed.  After installation, I found that the following databases at C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

AdventureWorks

AdventureWorksDW2008

AdventureWorksDW2008R2

AdventureWorksDW

AdventureWorksLT2008

AdventureWorksLT2008R2

AdventureWorksLT

The first code sample in the book uses the tables Person.BusinessEntity, Person.Person, and HumanResources.Employee, which none of these databases have.

I have tried downloading 'AdventureWorks2008R2_NovemberCTP.exe', but this does not have the database that I need either.

Does anyone know where I could get a copy of this database, as it seems that microsoft no longer supplies it.  I've tried a search engine to find it, but have had no success.  Any help would be greatly appreciated.

Answer 1

Hi again,

Please ignore this post.  I didn't have Filestream and Fulltextsearch set properly.  Once I did this, the OLTP database from the R2 installation had the tables that I need.

Answer 2

Thanks for updating the post and letting us know that you were successful.

Kind regards,

Gail

---

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

Answer 3

Hi MickySmig

I have the same problem you commented, i can't find the database.

I already read your solution.

Could you help me how to set filestream and fulltextsearch in order to use the databases correctly?

Thanks !!

Answer 4

Hi Luis.

(I'm doing this on a machine using Windows XP.  If you're using a different operating system, then the instructions will be slightly different)

To turn on FileStream

Select Start

   All Programs

      SQL Server 2008

          Configuration Tools

             SQL Server Configuration Manager

This will open the Configuration Manager Snap-in.

Then make sure that SQL Server Services is highlighted on the left hand side of the screen.  When this is the case, you'll need to right click 'SQL Server (MSSQLSERVER)' on the right hand side of the screen and select properties.  When the properties window comes up simply select the FILESTREAM tab and select the top checkbox.

To enable FullTextSearch

Above the entry for 'SQL Server (MSSQLSERVER)' you will see 'SQL Full-text Filter Daemon Launcher (MSSQLSERVER)'.  Simply set the start mode of this to Automatic.

Once you've done this, rerun the Adventureworks installer and the AdventureWorks2008 OLTP database will be available for install.

Hope this helps

MickySmig

 

Answer 5

Thanks for the post. I am also reading the book but just starting. I will post here if i find the link the the adventureworks for the rest of the chapters. Thanks again

Answer 6

Hi RXA,

I've found that the 'SR4' adventureworks database will work and has the table that I was missing.  For some reason, when I was installing the database, it was only installing some of the tables.  I believe this was due to me trying to install many different versions of the adventureworks family (although I'm not sure because I'm fairly new to all this).  I solved the problem by making sure that after deleting all the databases in the Management console, there wasn't any .mdf files still residing in the DATA folder.  Once I did this, the SR4 installer installed the version of the database that was required with the tables that the book needs.

The database required for chapter 7 and beyond also installed, once I changed the path to the DATA directory.

Answer 7

Hey Micky,

Thanks for putting the detail instructions....it helped me as well.

Pammi