June 12, 2008 at 4:13 pm
Hi,
I am looking to practice SSIS, SSAS, and SSRS and for that I need AdventureWorkdDW Database downloaded. I searched entire Microsoft site and googled it tirelessly but no luck. In Microsoft website there is a link to 'http://codeplex.com/SqlServerSamples' but this takes me to SQL Server 2008 RC0 Product samples which I dont want. And, when I go to 'http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004' web site this gives me the following downloads which does not seem to me 'AdventureWorksDW' database. So, can you please where do I go to get this sample file? Or, from the list below, which file should I pick to download? Also, I dont have SP2 with my SQL Server 2005 so when I download SP2, do I need to do something different? I appreciate your help on this. Thank you.
Files
AdventureWorksDB.msi
source code, 28053K, uploaded May 7 2007 - 216708 downloads AdventureWorksDBCI.msi
source code, 29177K, uploaded May 7 2007 - 29993 downloads AdventureWorksBI.msi
source code, 7393K, uploaded May 7 2007 - 49678 downloads AdventureWorksBICI.msi
source code, 16764K, uploaded May 7 2007 - 15837 downloads AdventureWorksLT.msi
source code, 2251K, uploaded May 7 2007 - 34813 downloads AdventureWorksDB_x64.msi
source code, 28075K, uploaded May 8 2007 - 4681 downloads AdventureWorksDBCI_x64.msi
source code, 29177K, uploaded May 8 2007 - 1587 downloads AdventureWorksBI_x64.msi
source code, 7393K, uploaded May 8 2007 - 2141 downloads AdventureWorksBICI_x64.msi
source code, 9021K, uploaded May 8 2007 - 1183 downloads AdventureWorksLT_x64.msi
source code, 2251K, uploaded May 8 2007 - 1810 downloads AdventureWorksDB_IA64.msi
source code, 28075K, uploaded May 8 2007 - 871 downloads AdventureWorksDBCI_IA64.msi
source code, 29177K, uploaded May 8 2007 - 577 downloads AdventureWorksBI_IA64.msi
source code, 7409K, uploaded May 8 2007 - 646 downloads AdventureWorksBICI_IA64.msi
source code, 8980K, uploaded May 8 2007 - 548 downloads AdventureWorksLT_IA64.msi
source code, 2251K, uploaded May 8 2007 - 1173 downloads
June 13, 2008 at 3:09 am
From this page download:
AdventureWorksDB.msi - OLTP database
AdventureWorksBI.msi - OLAP Database
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
June 13, 2008 at 3:23 am
Sorry that wasnt enough info.
Install those to files on your SQL server, attach the databases.
Also download SqlServerSamples.msi from the following address:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
Install and find sample of SSIS, SSRS and SSAS projects in the 'Program Files\Microsoft SQL Server\90\Samples' folder.
And it would be best to install SP2 to get these projects to work as they should.
MB
June 13, 2008 at 6:55 am
Thank you very much for your response. I downloaded those 3 files from the two links you provided. I went into Program files and folder C:\Program Files\Microsoft SQL Server\90\Samples and I see 7 folders (Analysis Services, Engine, Integrated Samples, Integrations Services, Notification Services, Replication, and Reporting Services). Now, when I go to for example Analysis Services folder I find Administrator, DataMining, Programmability, and Tutorils folders. I find similar for SSIS and SSRS. I am confused here...what folder should I click and how do I go about nevigating to find the file I downloaded to install those files. I am sorry if this sounds like spoon feeding but I really tried my options and with every step I am learning my way around. I appreciate your help with this. By the way, I am going to install SP2 as well. Thank you and looking forward to hearing from you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply