AdventureWorks Sample Databases

Community Content

In this section

Statistics Annotations (6)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 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.

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.

Other Resources

Considerations for Installing SQL Server Samples and Sample Databases

Help and Information

Getting SQL Server 2008 Assistance

Tags

: Add a tag

Flag as ContentBug

Is there a sample "AdventureWorks2008" database?

freabird ... Thomas Lee | Edit | Show History

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&