AdentureWorks 2005 or 2008?????

Question

I just downloaded and installed this on a fresh Hard Drive: SQL Server 2008 SR3 ( SQL2008.AdventureWorks_All_Databases.x86.msi )  Absolutely NO Problems, installed like a champ!!  My question is this:  The "TOP" database says "AdventureWorks"  not 'AdventureWorks2008'  What does this mean??  All the other builds I have downloaded in the past for 2008 versions say "AdventureWorks2008"  In fact if I expand the Database list I have a mixture of DataBases with and without the "2008" extension.

Can anyone verify that this build is ALL 2008 versions.  Why then do I have for example "AdventureWorksDW"  and "AdventureWorksDW2008" 

Is one the "2005" version??  If that is the case then my TOP database "AdventureWorks"  is not "AdventureWorks2008"

Can someone please clarify my consusion?? Are there certain tables etc.. I can look for to prove which verison I have?

Thanks,

Dave

Answer 1

Hello SQL Server 2008 Newbie,

The answer is really simple :
- If in the name of the database , you have 2008, it is a database which is specific for SQL Server 2008 ( you will find the use of FileStream which is
a new feature of SQL Sver 2008 ) . So this kind of database can only be installed in a SQL Server 2008 ). You can check it if you look at the
property  CompatibilityLevel  ( in SSMS, right click on the database, click on facets). It is set to 10
_ If in the name of the database, you have not 2008, it is a database foreseen to be installed on a SQL Server instance 2005 ( but you may install it on a SQL Server 2005 instance ( look at the property CompatibilityLevel, it will be equal to 9 ).

I have put a look on the creation script of the databases. All the features are accepted by the 2 versions 2005 and 2008 of SQL Server

You are talking of the TOP database. I suppose that in the databases list , you see AdventureWorks in the 1st place : it is normal as the comparison ( for any collation ) between "AdventureWorks" and "AdventureWorks2008" gives the string "AdventureWorks" < to "AdventureWorks2008" or even
"AdventureWorks 2008"

There are other differences between the 2 databases ( you have more tables in the 2008 db than in the 2005 db )

To check the version of a database, you could have a look on this link
http://msdn.microsoft.com/en-us/library/ms178534.aspx
select compatibility_level from sys_databases where name = N'AdventureWorks'
I am not sure the 2008 version is 'AdventureWorks2008' or 'AdventureWorks 2008'

Don't hesitate to post again for more help or explanations or if my reply is not incomplete or out of topic ( i have always problems with my poor english )


Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

Okay but here is the problem I foresee:  "Just starting out in SQL Server 2008, and Reporting Services I have to read a lot of books. A lot of the books use "AdventureWorks 2008" and I am afraid that the database that is supposed to be "AdventureWorks2008"  but only says "AdventureWorks" will cause me some grief with examples from books not working.  I really need to know for sure.

I downloaded a few weeks a go on my primary (main pc I use most often) PC this:

SQL2008.AdventureWorks_All_Databases.x86 (From CodePlex) and it gave me the following Databases:

AdventureWorks
AdventureWorks2008
AdventureWorksDW
AdventureWorksDW2008
AdventureWorksLT
AdventureWorksLT2008

First question:  Are all the above Databases "2008"  I do not understand why the installer package would install two each of the same database with just a different name. Or are the ones above missing the "2008 extension"  actually 2005 version?

Here is my second issue of confusion:  "My Main PC as stated above is dying"  I am trying to set up my secondary PC with the exact same setup, before my main pc dies.
Last night I installed SQL Server 2008 then instead of installing the file I already had for the AdventureWorks databases I decided to go out to CodePlex and get the latest build.  Mistake??  Do not know yet.  I thought the newer build would give me SAME set of Databases

http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=34032#ReviewsAnchor


Here is what I downloaded for my secondary PC assuming it would be the same as before. But I got a whole different set:

AdventureWorks
AdventureWorksDW
AdventureWorksDW2008
AdventureWorksLT
AdventureWorksLT2008

Again....... confusion... Where is "AdventureWorks2008"  Why do I have  'DW"  and "DW2008"  etc.. ??


"If I compare the "TABLES" of each download "AdventureWorks" match but when I pull up "AdventureWorks" on PC1, but when I pull up "AdventureWorks2008" on main PC and pull up the supposed AdventureWorks2008 named "AdventureWorks"  the tables do not match at all.


I would really like both systems set up the same.

Can I right click and "DELETE" ALL the AdventureWorks Databases from the secondary PC and just install the older .MSI install package so both systems have the same database?

I am afraid to "DELETE" them for fear I will get a bunch of errors trying to re-install the older MSI package.  Usually when you delete something, it never fails I get errors like this "Sorry you cannot install the databases, exisiting database exist..  you know what I mean..

I do not want to mess up a perfect install of AdventureWorks DB''s because they are a real pain to install sometimes.

"If you say the "AdventureWorks" is indeed a 2008 version, then why does it have different tables then  the known "AdventureWorks2008" on my main PC?? I still think something is wrong... it is like my installer package is missing "AdventureWorks2008"

Please give me some ideas.  I am too new at this to understand how  use the MOVE and REPLACE... I tried that earlier.  I have a .BAK file of AdventureWorks2008 but I cannot get my query to run without a bunch of errors.

Thanks,

Dave

Answer 3

Hi Dave,

>>First question:  Are all the above Databases "2008"  I do not understand why the installer package would install two each of the same database with just a different name. Or are the ones above missing the "2008 extension"  actually 2005 version?

The following databases were designed for SQL Server 2005 but will also work just fine on SQL Server 2008 and higher.
AdventureWorks    -- the OLTP database
AdventureWorksDW  -- the Data warehouse
AdventureWorksLT -- a smaller, simplified subset ofj the AdventureWorks data
 
The following databases were updated for SQL Server 2008 and will NOT work with SQL Server 2005.
AdventureWorks 2008   -- the OLTP database
AdventureWorksDW2008  -- the Data warehouse
AdventureWorksLT2008  -- a smaller, simplified subset ofj the AdventureWorks data

As you have discovered, there are 2 sets (families) of sample databases. The databases contain similar tables and data, however, there are schema differences between AdventureWorks and AdventureWorks2008 that explains why you are seeing differences when you look at the list of tables between the two.  For example, AdventureWorks contains a table named Person.Contact.  In AdventureWorks2008, this table is called Person.Person.  A few other tables have been deleted or renamed.  The details of the changes are described here: http://msftdbprodsamples.codeplex.com/wikipage?title=AW2008Details&referringTitle=Home

It's not a bad thing to have both the AdventureWorks and AdventureWorks2008 databases installed. You may need both at some point.  For example, some books use SQL Server 2008 for their examples, however, the product documentation (aka Books Online) still references AdventureWorks. 

>> Second question:  Why don't you see AdventureWorks2008 on your second PC?

My guess is that your instance of SQL Server on the 2nd machine does not meet the prequisites required to install AdventureWorks2008 and the installer installed the databases it could and silently failed when trying to install AdventureWorks2008 (as an aside, the samples team is aware of this issue and is working to resolve the problem).

My suggestion is that you verify the 2nd machine has full-text installed and FILESTREAM enabled. Follow the instructions in this Database Prerequisites topic to perform those tasks. http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites&referringTitle=Home.

Because you have AdventureWorks2008 on machine 1, you could detach the database from machine 1 and then attach the database on machine 2. 

Step 1.  Detach the database from machine 1.  See this topic for instructions http://msdn.microsoft.com/en-us/library/ms191491.aspx
Step 2.  Physically copy the AdventureWorks2008 files (there will be two files AdventureWorks2008_data.mdf and AdventureWorks2008_log.ldf) from machine 1 to machine2. By default these files are in the folder: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA,.
Step 3.  On machine 2, attach the database.  See this topic for instructions http://msdn.microsoft.com/en-us/library/ms190209.aspx

If you don't want to do the detach/attach process, then you should do the following:

1. From the Codeplex site you used to install the sample databases from, run the installation again.  It will prompt you to repair or remove the current sample database installation.  Choose to remove the sample databases.  (I believe you can also do this from Contro Panel Add/Remove programs as well).

2. Reinstall the sample databases from Codeplex.

Kind Regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights