Installing Sample Databases on SQL Server 2008

Installing the Samples for SQL Server 2008 is one of the worst experience I have had with SQL Server to date.

While not the hardest thing in the world to accomplish, accurate documentation and a website with easy to follow instructions would have saved me a lot of time. It took me the better part of 2 hours going through the site and running in circles, only to realize that I could be fully setup in about 15 minutes, had there been easier instructions to follow.

Step 1. 

Download the SQL2008.AdventureWorks_All_DB_Scripts.x86.msi file from Codeplex.

After running the setup, go to the C:\Program Files\Microsoft SQL Server\100\Tools\Samples directory.

Step 2.

Run the following commands from your command line 

cd "C:\Program Files\Microsoft SQL Server\100\Tools\Samples"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorks"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorks2008"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorksDW"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorksDW2008"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorksLT"
buildadventureworks.cmd "%PROGRAMFILES%\Microsoft SQL Server\100\" "." "AdventureWorksLT2008"

Use (local) if you have the default instance installed, or for a named instance use “.\INSTANCENAME”

Step 3. 

Get to work…

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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