Adventure Works vs AdventureWorks2008 database

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?
vbnetcoderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

becraigCommented:
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
vbnetcoderAuthor Commented:
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
becraigCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

vbnetcoderAuthor Commented:
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
becraigCommented:
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
vbnetcoderAuthor Commented:
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
becraigCommented:
Yup that URL as indicated above should have all the samples.

I hope this is resolved for you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vbnetcoderAuthor Commented:
ty
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.