Geeks With Blogs

News
Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Creative Commons License


Check out my about.me profile!

INETA Community Speakers Program

Follow enriquelima on Twitter
Locations of visitors to this page

Intentional Thinking Enrique Lima

For a while now, if we have been around SQL Server we got used to the different sample databases that were provided.  From Pubs to Northwind to AdventureWorks.

In order to get the AdventureWorks samples we need to go to CodePlex and download the one that corresponds to the version of SQL Server we are working with.  The link to the download site here : http://msftdbprodsamples.codeplex.com/releases/view/55926

Now, on to the installation.

Once you download the appropriate file, double click and launch the  installation process.

image

Which in turn becomes this

image

You will need to accept the license terms to continue

Then you will select the component of the sample content to install.  The OLTP content (relational DBs, in blue) will install and be ready to go once the install completes.  The OLAP content (Analysis services content, in orange) will require some additional steps to complete the installation process.  Important to note is the option to select the Instance where the Databases will be installed to.

image

Installation process begins

image

It completes, then click Finish

image

This is how the content gets installed.  The next post is about getting the Analysis services content deployed.

Posted on Saturday, October 29, 2011 8:08 AM SQL Server , Learning | Back to top


Comments on this post: Installing the AdventureWorks Community Sample Database content

comments powered by Disqus

Copyright © Enrique Lima | Powered by: GeeksWithBlogs.net