Installing MS AdventureWorks 2008

If you download the SQL2008 AdventureWorks sample and run the .msi installer package, the installer checks whether Full-Text Search and FileStream support are enabled on the SQL Server instance you specified, but the installer will not install the database(s). The only thing it does is extract the msi to the specified locations. The comments on the Readme page indicate that this did not only happen to me.


Open a command prompt window in the 100 directory of the SQL Server program files:

cd C:\Program Files\Microsoft SQL Server\100

and run the CreateAdventureWorks.cmd with the parameters: instance name, script path, and data path

    "%PROGRAMFILES%\Microsoft SQL Server\100\tools\samples\"

This batch file will execute the SQL files for the 6 databases being created:

"%_sourcepath%AdventureWorks OLTP\instawdb.sql" (940k)
"%_sourcepath%AdventureWorks Data Warehouse\instawdwdb.sql" (50k)
"%_sourcepath%AdventureWorks LT\instawltdb.sql"  (200k)
"%_sourcepath%AdventureWorks 2008 OLTP\instawdb.sql" (964k)
"%_sourcepath%AdventureWorks 2008 Data Warehouse\instawdwdb.sql" (56k)
"%_sourcepath%AdventureWorks 2008 LT\instawltdb.sql" (203k)

where %_sourcepath% is set to the value of the script path parameter you provided. Numbers in parens show approximate file size in kB.

The .sql files create all database objects and fill the tables with sample data using BULK INSERT.

After the batch file has completed, you will see 6 new databases in Management Studio:

  • AdventureWorks
  • AdventureWorksLT
  • AdventureWorksDW
  • AdventureWorks2008
  • AdventureWorksLT2008
  • AdventureWorksDW2008

One Response to Installing MS AdventureWorks 2008

  1. […] installing SQL Server 2008 and AdventureWorks, I found that, besides some other shortcomings, SMOscript would not connect to an SQL Server 2008. […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: