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