O'Reilly logo

Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services by Mike Davis, Devin Knight, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Installing the Sample Databases

You will need two sample databases for the tutorials in this book and throughout the Microsoft Books Online tool built into SQL Server 2008. The AdventureWorks2008 database is an example database that simulates a bike retailer. It contains HR, accounting, and sales data for online transactions and store sales. The AdventureWorksDW2008 database is an example data warehouse for the same bike reseller.

The two sample databases are not installed by default with SQL Server 2008. You can download these and other sample databases from CodePlex.com (http://www.codeplex.com/MSFTDBProdSamples/). CodePlex is Microsoft's community website where you can find projects and source code to extend SQL Server. The site is constantly updated and the sample databases are updated often as well.

You can also find the sample databases at the Wrox website at http://www.wrox.com/go/SQLServer2008RTMDataSets.

The AdventureWorks2008 database requires that the Full Text Search feature be installed and that the new FileStream feature be enabled in SQL Server 2008. In addition the SQL Server Full Text service must be running. Without these, you can still install the AdventureWorksDW2008 database but not the AdventureWorks database.

To install the Full Text Search feature, you must go back to the SQL Server Installation Center under SQL Server 2008

Installing the Sample Databases

The new FileStream feature ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required