SQL Server 2008 Books Online (November 2009)
AdventureWorks Sample Databases

SQL Server introduces the Adventure Works Cycles company. This company with its business scenarios, employees, and products is the basis for the following sample databases:

  • AdventureWorks sample OLTP database
  • AdventureWorksDW sample data warehouse
  • AdventureWorksAS sample analysis services database

These databases are used in the code examples in SQL Server Books Online, and in code samples that can be downloaded from the Microsoft SQL Server Sam p les and Community Projects home page.

ms124501.note(en-us,SQL.100).gifImportant:
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.

In This Section

Topic Description

Adventure Works Cycles Business Scenarios

Describes Adventure Works Cycles, the fictitious company on which the sample databases are based, and the business scenarios used to determine the design of the databases.

AdventureWorks Sample OLTP Database

Describes in detail the AdventureWorks sample OLTP database.

AdventureWorks Sample Data Warehouse

Describes AdventureWorksDW, the sample data warehouse used in Books Online to demonstrate the business intelligence features that are available in SQL Server.
See Also

Other Resources

Considerations for Installing SQL Server Samples and Sample Databases

Help and Information

Getting SQL Server 2008 Assistance
Tags : don's tag


Community Content

emerald77
Please update SQL Server "End-to-End Samples" to support AW2008 and "Business Entity" concept

I would like to see much more detailed information about AW2008 and, in particular, how to use BusinessEntityIDs. I was surprised to discover that the "Microsoft End-to-End Samples" (see http://www.codeplex.com/SqlServerSamples#e2e), for example, have not been updated to support AdventureWorks2008.

Based on the changes made to AW2008 (see http://msftdbprodsamples.codeplex.com/Wiki/View.aspx?title=AW2008Details), I am very interested in learning about and understanding the "business entity" concept.

Thanks.

Tags :

Thomas Lee
Is there a sample "AdventureWorks2008" database?
Is there a sample database named "AdventureWorks2008" specifically? I have several similarly named databases on my machine after some effort trying to get some SQL Server 2008 samples running. If there is one named as above, do I need to delete all of the other ones I have (listed below) before using the 2008 version? If so do they need to be "detached" or simply deleted from my hard drive? It would be helpful if someone could post a link to download AventureWorks2008 if such a database exists.

These are the databases I have:

AdventureWorksDW2008_Data.mdf

AdventureWorksDW_Data.mdf

AdventureWorksLT2008_Data.mdf

AdventureWorksLT_Data.mdf

AdventureWorks_Data.mdf


Should these be deleted if there is an AdventureWorks2008 database to replace them?

Thanks a bunch...


[tfl - 03 08 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at

http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
PowerShell : http://groups.google.com/group/microsoft.public.windows.powershell/topics?pli=1
All Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&


Page view tracker