3 out of 9 rated this helpful - Rate this topic

AdventureWorks Sample Databases

SQL Server 2008

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 Samples and Community Projects home page.

Important
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.

Tasks

Considerations for Installing SQL Server Samples and Sample Databases

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

AdventureWorks

History

10/24/2010
iahadi

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&

History

7/28/2009
freabird

8/3/2009
Thomas Lee

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.

History

4/21/2009
emerald77