Set Up
To build the sample in this walkthrough, some initial setup is required.
- You will need to install the AdventureWorksLT database on your SQL server. This sample database is available on CodePlex. Because the database sample is dependent on your version of SQL Server, we have provided links below to the AdventureWorks LT sample for different SQL versions.
- You will also need to create a database on your SQL server named AdventureWorksLTDataMart.
| SQL Server Version | Download Link |
|---|---|
| SQL Server 2008 R2 | http://msftdbprodsamples.codeplex.com/releases/view/55926 |
| SQL Server 2008 | http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=106391 |
| SQL Server 2005 (32-bit) | http://msftdbprodsamples.codeplex.com/releases/view/4004#DownloadId=11757 |
| SQL Server 2005 (64-bit) | http://msftdbprodsamples.codeplex.com/releases/view/4004#DownloadId=11813 |