Friday, June 05, 2009 6:51 PM
so I downloaded the AdventureWorksDB from
this package because I have a x64 server? AdventureWorksDB_x64.msi
I can install and attach it just fine but the Tutorial does not match up at all? So far.
when Defining a Data Source View instructs to select these tables
these table do not exist in the sample database?
What gives; what adventure works db do I need to get to be able to follow the tutorials?
Monday, June 22, 2009 11:54 AMPlease get the SQL Server 2005 sample all-in-one package from http://sqlserversamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=4000&DownloadId=11735. That one should work well with the SQL Server 2005 Tutorial you found.
You probably have downloaded a newer version of AdventureWorks database, in which the schema has changed(to accommodate some new samples in SQL Server 2008 or later.)
Monday, June 22, 2009 12:18 PMThe database should install for this tutorial is AdventureWorksBI.msi or the x64 version one in http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004. BI means business intelligence(Analysis Service is part of BI). I think these two are same. Only the x64 setup is for x64(my guess). But it definitely has the tables like DimTime, DimProduct etc.