[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Adventure Works vs AdventureWorks2008 database

Posted on 2014-08-30
8
Medium Priority
?
187 Views
Last Modified: 2014-09-02
I am doing some practicing with SQL Server and I have instructions to download the AdventureWorks databases as well the AdventureWorks2008 database.  I was able to download AdventureWorks2008 but don't now where to find the AdventureWorks database without the 2008.  Is there much of a difference in the first place?
0
Comment
Question by:vbnetcoder
  • 4
  • 4
8 Comments
 
LVL 29

Expert Comment

by:becraig
ID: 40295009
These are just dummy databases provided for testing purposes.

If you have SQL 2008, having the Adventure Works 2008 DB will suffice, there is no need to add the other version of the DB.

The sample databases generally match the sql version and can be downloaded online:
http://msftdbprodsamples.codeplex.com/

Simply search for the version you need, that will match your sql version.
0
 

Author Comment

by:vbnetcoder
ID: 40295042
The training materials that I am using don't match up schema wise with the 2008 databases.  So, do you know if i can get the regular AventureWorks db without the 2008?
0
 
LVL 29

Expert Comment

by:becraig
ID: 40295045
Figure out which Adventure works DB that training material you have works with or just get updated version of the material.

If it is not 2008 then it probably is 2005 - you should be able to see that based on the training documentation.

Whichever one it is you can get it at the link I provided above.
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:vbnetcoder
ID: 40295046
According to the picture there is a database called AdventureWorks (without a year after it). So far, its not a big deal I just have to figure out the new schema.
0
 
LVL 29

Expert Comment

by:becraig
ID: 40295048
Ok, you can look at the different versions here:
http://msftdbprodsamples.codeplex.com/releases/view/93587

Anything prior to that would be 2005 or 2000


That should get you where you need to be.
0
 

Author Comment

by:vbnetcoder
ID: 40296955
I learned that the origional db AdventureWorks DB was in SQL server 2005 and i was able to download it from here

http://msftdbprodsamples.codeplex.com/releases/view/4004
0
 
LVL 29

Accepted Solution

by:
becraig earned 2000 total points
ID: 40298898
Yup that URL as indicated above should have all the samples.

I hope this is resolved for you.
0
 

Author Closing Comment

by:vbnetcoder
ID: 40298998
ty
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question