Databases Reference
In-Depth Information
Installing sample databases
We will be working with Microsoft's Northwind database and sometimes with the
more recent AdventureWorks databases in both SQL Server 2012. These database
samples comes in two forms—MDF and LDF iles or script iles, which when run
on the server install the databases. The MDF and LDF iles can be used to install the
samples by using either the graphic user interface (right-click on the Databases node
in the SQL Server Management Studio and choose Attach... ), the Attach menu item
on SQL Server, or by using T-SQL scripts.
Downloading iles and running scripts
For SQL Server 2000 database iles, refer to the follow URL:
http://www.microsoft.com/en-us/download/details.aspx?id=23654
For Adventure Works database iles, refer to the follow URL :
http://msftdbprodsamples.codeplex.com/releases
Make sure you get both the MDF and LDF iles, as both are needed
while attaching the databases; read the following comments at
http://msftdbprodsamples.codeplex.com/workitem/19203 .
For attaching the MDF/LDF iles, refer to the following URL for a step-by-step
procedure:
http://hodentek.blogspot.com/search?q=Sample+databases
For running the script iles, refer to the follow URL and following the steps
as indicated:
http://hodentekmsss.blogspot.com/2013/01/how-do-i-install-sample-
database-using.html
In addition to these iles, some data and even tables may be created to describe some
aspects of Reporting Services, and these will be described at appropriate places.
 
Search WWH ::




Custom Search