Dec 09
24
AdventureWorks…
Adventureworks is a huge sample database of a make believe bike company provider by Microsoft, and l find this particularly useful when working on/learning OLTP and SSAS – ie Online transaction processing as well as SQL Server analysis services used to make business intelligence decisions, datamarts etc.
Helpful notes:
- download the latest version from codeplex – click here - the file l got was AdventureWorks2008_SR4.exe
- Run this program
- For installing SSAS - SQL Server Analysis Services database see this webpage
- Look for the install scripts in C:\Program Files\Microsoft SQL Server\100\Tools\Samples\
- dont forget to execute the scripts in sqlcmd mode,
Look for code like:
–:setvar SqlSamplesDatabasePath “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\”
–:setvar SqlSamplesSourceDataPath “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\”
In the scripts, in the sample source path folder on your workstation, make sure you modify and set correctly at least the top line for the sql samples database path
Also, make sure if you made modifications to your model database default size, you adjust the database file size in the create database portion of the script as eg:
CREATE DATABASE [AdventureWorks2008]
ON (NAME = ‘AdventureWorks2008_Data’, FILENAME = N’$(SqlSamplesDatabasePath)AdventureWorks2008_Data.mdf’, SIZE = 170, FILEGROWTH = 8),
FILEGROUP DocumentFileStreamGroup CONTAINS FILESTREAM ( NAME = FileStreamDocuments, FILENAME = N’$(SqlSamplesDatabasePath)Documents’)
LOG ON (NAME = ‘AdventureWorks2008_Log’, FILENAME = N’$(SqlSamplesDatabasePath)AdventureWorks2008_Log.ldf’ , SIZE = 2, FILEGROWTH = 96);
GO