AdventureWorksDW for Analysis services

Any body has a link for downloading that DB ? (Other than codeplex.com please !)

The one i have downloaded from codeplex produce errors related to missing (Data1.cab) File.

Any links ?

I've been VERY frustrated with Codex as well.

The best solution I've found is to go back to the SQL Server installation disk and reinstall the samples. If you installed these earlier, there is a script that will rebuild and load the Adventure Works DW relational database. (You will need to modify the data file path in the script.) You will then need to assemble the OLAP database using the provided solution.

B.

adventureworks installation

I downloaded and installed the .msi from codeplex. After installation I open SQL Server Management Studio but don't see AdventureWorksDB in the list of databases. How is this possible? Should I not be seeing this new database? Do I have to do something else?

From within the sql server studio, right click on the databases entry. The task you are looking for is "attach database".

Grab the .mdf file for the adventure works db. ( It may try to grab a .log file that is in the wrong directory, if so, delete the reference to it on the screen. It will create another log file in the same directory as the .mdf file.)

sql

AdventureWorks Install

I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?
No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>
|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...

> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com
|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net.. .
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com

AdventureWorks Install

I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
--
Regards
Pawel Potasinski
U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I am
> going through the tutorial and it's asking me to create the following query:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>> I have another DB (storeDB) on the server and I am able to see all the
>> tables under Databases > System Databases > storeDB > Tables > System
>> Tables, but I am unable to see the System Tables under AdventureWorks. I
>> am
>> going through the tutorial and it's asking me to create the following
>> query:
>> SELECT * FROM Production.Product;
>> GO
>> and I receive this error message:
>> Msg 208, Level 16, State 1, Line 1
>> Invalid object name 'Production.Product'.
>> I have a connection the AdventureWorks DB. I'm obviously new to SQL
>> Server
>> 2005.
>> Any help would be appreciated.
>> Regards, Richard
>> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
>> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>> No, it's normal in SQL Server 2005. System tables are hidden and you
>> can't
>> see or modify them directly.
>> --
>> Regards
>> Pawel Potasinski
>>
>> U¿ytkownik "Richard" <rich_a_wms@.yahoo.com> napisa³ w wiadomo¶ci
>> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>>I am using sqlserver 2005 express edition and have downloaded the
>> AdventureWorksDB.msi. I have installed it and it created 3 files:
>> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
>> AdventureWorks_log.idf (~1MB). When I added the database to the
>> sqlserver,
>> no tables appear under system tables. Is there something I am missing
>> here?
>>
>>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com

AdventureWorks Install

I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
no tables appear under system tables. Is there something I am missing here?No, it's normal in SQL Server 2005. System tables are hidden and you can't
see or modify them directly.
Regards
Pawel Potasinski
Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>I am using sqlserver 2005 express edition and have downloaded the
> AdventureWorksDB.msi. I have installed it and it created 3 files:
> AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
> AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,
> no tables appear under system tables. Is there something I am missing
> here?
>
>|||I have another DB (storeDB) on the server and I am able to see all the
tables under Databases > System Databases > storeDB > Tables > System
Tables, but I am unable to see the System Tables under AdventureWorks. I am
going through the tutorial and it's asking me to create the following query:
SELECT * FROM Production.Product;
GO
and I receive this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Production.Product'.
I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
2005.
Any help would be appreciated.
Regards, Richard
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...

> No, it's normal in SQL Server 2005. System tables are hidden and you can't
> see or modify them directly.
> --
> Regards
> Pawel Potasinski
>
> Uytkownik "Richard" <rich_a_wms@.yahoo.com> napisa w wiadomoci
> news:u4xAciayHHA.748@.TK2MSFTNGP04.phx.gbl...
>|||On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
[vbcol=seagreen]
> I have another DB (storeDB) on the server and I am able to see all the
> tables under Databases > System Databases > storeDB > Tables > System
> Tables, but I am unable to see the System Tables under AdventureWorks. I a
m
> going through the tutorial and it's asking me to create the following quer
y:
> SELECT * FROM Production.Product;
> GO
> and I receive this error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'Production.Product'.
> I have a connection the AdventureWorks DB. I'm obviously new to SQL Server
> 2005.
> Any help would be appreciated.
> Regards, Richard
> "Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
> news:OLCmDdcyHHA.1776@.TK2MSFTNGP03.phx.gbl...
>
Looks like a permissions issue. If you are just testing, make your account
you log in as a Server Role of Sysadmin (God-level rights).
Chuck Lathrope
www.sqlwebpedia.com|||Thanks, I changed permissions, but I still can't see the tables. The strange
thing is that there are 3 files in the Data folder under the MSSQL folder
for AdventureWorks: AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~
164MB) and AdventureWorks_log.idf (~1MB). The other DB's on the server only
have 2 files (.mdf and .idf) for each database. There are no _Data.mdf
files.
Regards, Richard
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:rugaxfto4xox$.1xm17ldm6wy7j$.dlg@.40tude.net...
> On Thu, 19 Jul 2007 12:53:50 -0700, Richard wrote:
>
> Looks like a permissions issue. If you are just testing, make your account
> you log in as a Server Role of Sysadmin (God-level rights).
> Chuck Lathrope
> www.sqlwebpedia.com

AdventureWorks db for 101 Samples

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct.
I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this database? It is a SQL 2005 database, I think.
Thanks!

You can download AdventureWorks from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en

|||Thanks a lot, Gail!|||I'm using the version of SQL Server 2005 Express that comes together with Visual Studio 2005 Beta 2. When I try to attach the AventureWorks db, there is an error.

The database 'AdventureWorks' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

What version of SQL Server 2005 is required? Could it work with my VS.NET 2005 Beta 2?
Thanks!|||Hi blackpuppy,
You'll need the June CTP version of SQL Server Express, which will work just fine with your VS Beta 2. You can download that version from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en

Before you install SQL Server Express, using Control Panel | Add/Remove Programs to uninstall your current version of .NET Framework 2.0.

Install the version of .NET Framework 2.0 from the SQL Server Express download site and then install SQL Server Express.|||Are you saying that instead of installing appropriate version of AdventureWorks, sql server 2005 Express has to be installed (downloaded from the internet)? I got installation of sql server 2005 CTP from Microsoft, after attending webcast sessions, and it didn't include AdventureWorks database. Now I'm trying to learn something about 2005, and sample database would really help. I don't want to reinstall Express because it won't include all tools I need for learning.
Is it possible to download somewhere appropriate version of this sample database?
Thanks,
Edi|||

What I'm asking is is there anywhere older copy of AdventureWorks, compatible with Sqlserver 2005 CTP?
Thanks

|||

The version of AdventureWorks at this site : http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en
is the appropriate version for SQL Server 2005 June CTP release and SQL Server Express 2005 June CTP.

If your version of SQL Server is older than that, then you may have problems using the sample database available from this site. However, it's not clear to me what version of SQL Server you really have or whether you have SQL Server Express or the Developer edition of SQL Server. Can you run SELECT @.@.VERSION and report back the result? This will identify your SQL Server version and help solve the issue.

|||Well... I have SQL Server 2005 Express Loaded from the June CTP (version 9.00.1128.00) and the above AdventureWorks and it still doesn't work!!!

I still get the error above!... Is there anything else that would work? or better yet are there any other samples out there to down load?

thanks,
ward0093|||

Okay. I've forwarded this to the samples team for further investigation. I'll report back when I get morre information.

In the meantime, if you want other sample databases, you can certainly download and install the pubs and northwind sample databaes from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en

|||Thanks Gail....

I got it working on my Laptop by still not be development machine... and it was the same install for both machines.

Not sure what the deal is

ward0093|||How did you get it working? I am experiencing the same problem and was unable to install a different version of sql express after uninstalling the version that is bundled with VS beta 2.|||

I just downloaded the samples, and the adventureworksdb. The db doesn't have the sample table layout as the samples. The new version is highly normalized. Is there somewhere to get the older db?

Thanks.

|||

I don't understand what you mean by "The db doesn't have the sample table layout as the samples. " Can you be more specific? The database schema has not changed since the June CTP version, so I'm not sure what you're referring to.

Thanks.

|||

gaile-

Thanks for your quick response. Specifically, from CreatingMasterDetails sample:

SELECT EmployeeID, NationalIDNumber, ContactID, LoginID, DepartmentID, ManagerID, ShiftID, Title, EmergencyContactID, AddressID, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, BaseRate, PayFrequency, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate FROM HumanResources.Employee WHERE (EmployeeID = @.@.IDENTITY)

Several of these fields are not in the employee table (DepartmentID, ShiftID, AddressID...). Is the db different for express and server? The downloaded msi's are the same size. I'm using SQLServer2005.

Thanks.

-Gary

sql

AdventureWorks db for 101 Samples

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct.
I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this database? It is a SQL 2005 database, I think.
Thanks!

You can download AdventureWorks from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en

|||Thanks a lot, Gail!|||I'm using the version of SQL Server 2005 Express that comes together with Visual Studio 2005 Beta 2. When I try to attach the AventureWorks db, there is an error.

The database 'AdventureWorks' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

What version of SQL Server 2005 is required? Could it work with my VS.NET 2005 Beta 2?
Thanks!

|||Hi blackpuppy,
You'll need the June CTP version of SQL Server Express, which will work just fine with your VS Beta 2. You can download that version from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en

Before you install SQL Server Express, using Control Panel | Add/Remove Programs to uninstall your current version of .NET Framework 2.0.

Install the version of .NET Framework 2.0 from the SQL Server Express download site and then install SQL Server Express.|||Are you saying that instead of installing appropriate version of AdventureWorks, sql server 2005 Express has to be installed (downloaded from the internet)? I got installation of sql server 2005 CTP from Microsoft, after attending webcast sessions, and it didn't include AdventureWorks database. Now I'm trying to learn something about 2005, and sample database would really help. I don't want to reinstall Express because it won't include all tools I need for learning.
Is it possible to download somewhere appropriate version of this sample database?
Thanks,
Edi|||

What I'm asking is is there anywhere older copy of AdventureWorks, compatible with Sqlserver 2005 CTP?
Thanks

|||

The version of AdventureWorks at this site : http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en
is the appropriate version for SQL Server 2005 June CTP release and SQL Server Express 2005 June CTP.

If your version of SQL Server is older than that, then you may have problems using the sample database available from this site. However, it's not clear to me what version of SQL Server you really have or whether you have SQL Server Express or the Developer edition of SQL Server. Can you run SELECT @.@.VERSION and report back the result? This will identify your SQL Server version and help solve the issue.

|||Well... I have SQL Server 2005 Express Loaded from the June CTP (version 9.00.1128.00) and the above AdventureWorks and it still doesn't work!!!

I still get the error above!... Is there anything else that would work? or better yet are there any other samples out there to down load?

thanks,
ward0093|||

Okay. I've forwarded this to the samples team for further investigation. I'll report back when I get morre information.

In the meantime, if you want other sample databases, you can certainly download and install the pubs and northwind sample databaes from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en

|||Thanks Gail....

I got it working on my Laptop by still not be development machine... and it was the same install for both machines.

Not sure what the deal is

ward0093|||How did you get it working? I am experiencing the same problem and was unable to install a different version of sql express after uninstalling the version that is bundled with VS beta 2.|||

I just downloaded the samples, and the adventureworksdb. The db doesn't have the sample table layout as the samples. The new version is highly normalized. Is there somewhere to get the older db?

Thanks.

|||

I don't understand what you mean by "The db doesn't have the sample table layout as the samples. " Can you be more specific? The database schema has not changed since the June CTP version, so I'm not sure what you're referring to.

Thanks.

|||

gaile-

Thanks for your quick response. Specifically, from CreatingMasterDetails sample:

SELECT EmployeeID, NationalIDNumber, ContactID, LoginID, DepartmentID, ManagerID, ShiftID, Title, EmergencyContactID, AddressID, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, BaseRate, PayFrequency, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate FROM HumanResources.Employee WHERE (EmployeeID = @.@.IDENTITY)

Several of these fields are not in the employee table (DepartmentID, ShiftID, AddressID...). Is the db different for express and server? The downloaded msi's are the same size. I'm using SQLServer2005.

Thanks.

-Gary

AdventureWorks db for 101 Samples

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct.
I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this database? It is a SQL 2005 database, I think.
Thanks!

You can download AdventureWorks from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en

|||Thanks a lot, Gail!|||I'm using the version of SQL Server 2005 Express that comes together with Visual Studio 2005 Beta 2. When I try to attach the AventureWorks db, there is an error.

The database 'AdventureWorks' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

What version of SQL Server 2005 is required? Could it work with my VS.NET 2005 Beta 2?
Thanks!|||Hi blackpuppy,
You'll need the June CTP version of SQL Server Express, which will work just fine with your VS Beta 2. You can download that version from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en

Before you install SQL Server Express, using Control Panel | Add/Remove Programs to uninstall your current version of .NET Framework 2.0.

Install the version of .NET Framework 2.0 from the SQL Server Express download site and then install SQL Server Express.|||Are you saying that instead of installing appropriate version of AdventureWorks, sql server 2005 Express has to be installed (downloaded from the internet)? I got installation of sql server 2005 CTP from Microsoft, after attending webcast sessions, and it didn't include AdventureWorks database. Now I'm trying to learn something about 2005, and sample database would really help. I don't want to reinstall Express because it won't include all tools I need for learning.
Is it possible to download somewhere appropriate version of this sample database?
Thanks,
Edi|||

What I'm asking is is there anywhere older copy of AdventureWorks, compatible with Sqlserver 2005 CTP?
Thanks

|||

The version of AdventureWorks at this site : http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en
is the appropriate version for SQL Server 2005 June CTP release and SQL Server Express 2005 June CTP.

If your version of SQL Server is older than that, then you may have problems using the sample database available from this site. However, it's not clear to me what version of SQL Server you really have or whether you have SQL Server Express or the Developer edition of SQL Server. Can you run SELECT @.@.VERSION and report back the result? This will identify your SQL Server version and help solve the issue.

|||Well... I have SQL Server 2005 Express Loaded from the June CTP (version 9.00.1128.00) and the above AdventureWorks and it still doesn't work!!!

I still get the error above!... Is there anything else that would work? or better yet are there any other samples out there to down load?

thanks,
ward0093|||

Okay. I've forwarded this to the samples team for further investigation. I'll report back when I get morre information.

In the meantime, if you want other sample databases, you can certainly download and install the pubs and northwind sample databaes from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en

|||Thanks Gail....

I got it working on my Laptop by still not be development machine... and it was the same install for both machines.

Not sure what the deal is

ward0093|||How did you get it working? I am experiencing the same problem and was unable to install a different version of sql express after uninstalling the version that is bundled with VS beta 2.|||

I just downloaded the samples, and the adventureworksdb. The db doesn't have the sample table layout as the samples. The new version is highly normalized. Is there somewhere to get the older db?

Thanks.

|||

I don't understand what you mean by "The db doesn't have the sample table layout as the samples. " Can you be more specific? The database schema has not changed since the June CTP version, so I'm not sure what you're referring to.

Thanks.

|||

gaile-

Thanks for your quick response. Specifically, from CreatingMasterDetails sample:

SELECT EmployeeID, NationalIDNumber, ContactID, LoginID, DepartmentID, ManagerID, ShiftID, Title, EmergencyContactID, AddressID, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, BaseRate, PayFrequency, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate FROM HumanResources.Employee WHERE (EmployeeID = @.@.IDENTITY)

Several of these fields are not in the employee table (DepartmentID, ShiftID, AddressID...). Is the db different for express and server? The downloaded msi's are the same size. I'm using SQLServer2005.

Thanks.

-Gary

AdventureWorks db for 101 Samples

I'm not sure if this should be asked here. If it's the wrong place, let me know and I'll correct.
I've just downloaded 101 Samples for Visual Studio 2005. But the data access samples require AdventureWorks database which is not included in the C# sample. Who know where I can get this database? It is a SQL 2005 database, I think.
Thanks!

You can download AdventureWorks from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en

|||Thanks a lot, Gail!|||I'm using the version of SQL Server 2005 Express that comes together with Visual Studio 2005 Beta 2. When I try to attach the AventureWorks db, there is an error.

The database 'AdventureWorks' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

What version of SQL Server 2005 is required? Could it work with my VS.NET 2005 Beta 2?
Thanks!

|||Hi blackpuppy,
You'll need the June CTP version of SQL Server Express, which will work just fine with your VS Beta 2. You can download that version from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en

Before you install SQL Server Express, using Control Panel | Add/Remove Programs to uninstall your current version of .NET Framework 2.0.

Install the version of .NET Framework 2.0 from the SQL Server Express download site and then install SQL Server Express.|||Are you saying that instead of installing appropriate version of AdventureWorks, sql server 2005 Express has to be installed (downloaded from the internet)? I got installation of sql server 2005 CTP from Microsoft, after attending webcast sessions, and it didn't include AdventureWorks database. Now I'm trying to learn something about 2005, and sample database would really help. I don't want to reinstall Express because it won't include all tools I need for learning.
Is it possible to download somewhere appropriate version of this sample database?
Thanks,
Edi|||

What I'm asking is is there anywhere older copy of AdventureWorks, compatible with Sqlserver 2005 CTP?
Thanks

|||

The version of AdventureWorks at this site : http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en
is the appropriate version for SQL Server 2005 June CTP release and SQL Server Express 2005 June CTP.

If your version of SQL Server is older than that, then you may have problems using the sample database available from this site. However, it's not clear to me what version of SQL Server you really have or whether you have SQL Server Express or the Developer edition of SQL Server. Can you run SELECT @.@.VERSION and report back the result? This will identify your SQL Server version and help solve the issue.

|||Well... I have SQL Server 2005 Express Loaded from the June CTP (version 9.00.1128.00) and the above AdventureWorks and it still doesn't work!!!

I still get the error above!... Is there anything else that would work? or better yet are there any other samples out there to down load?

thanks,
ward0093|||

Okay. I've forwarded this to the samples team for further investigation. I'll report back when I get morre information.

In the meantime, if you want other sample databases, you can certainly download and install the pubs and northwind sample databaes from this site: http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en

|||Thanks Gail....

I got it working on my Laptop by still not be development machine... and it was the same install for both machines.

Not sure what the deal is

ward0093|||How did you get it working? I am experiencing the same problem and was unable to install a different version of sql express after uninstalling the version that is bundled with VS beta 2.|||

I just downloaded the samples, and the adventureworksdb. The db doesn't have the sample table layout as the samples. The new version is highly normalized. Is there somewhere to get the older db?

Thanks.

|||

I don't understand what you mean by "The db doesn't have the sample table layout as the samples. " Can you be more specific? The database schema has not changed since the June CTP version, so I'm not sure what you're referring to.

Thanks.

|||

gaile-

Thanks for your quick response. Specifically, from CreatingMasterDetails sample:

SELECT EmployeeID, NationalIDNumber, ContactID, LoginID, DepartmentID, ManagerID, ShiftID, Title, EmergencyContactID, AddressID, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, BaseRate, PayFrequency, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate FROM HumanResources.Employee WHERE (EmployeeID = @.@.IDENTITY)

Several of these fields are not in the employee table (DepartmentID, ShiftID, AddressID...). Is the db different for express and server? The downloaded msi's are the same size. I'm using SQLServer2005.

Thanks.

-Gary

Adventure Works DB Samples with Express 2005 SQL Server

Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005?

You can put it in any folder you want to (normally in the usual data folder you are using, by default this is located somehwere in the programe files , microsoft SQL Server directory. But you have to attach the database using the sp_attachdb procedure or use the GUI to attach the database, right click on the server --> attach database and you are done.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||You can attach DB's in the Management Studio Express then?|||Should be able to, right click on the Databases folder, if it is not listed try All Tasks|||did you get this to work ?I have attached the database and still could not get the report designer towork with the database.