Download Microsoft AdventureWorks Database

31 באוקטובר 2007

תגובה אחת

Usually when we start writing a new program, or just playing with LINQ, we need a database with some information on it like tables, stored procedures and some data to play with.

Microsoft offers a complete database called AdventureWorks just for that cause.

The database contains more then 50 tables, 9 stored procedures and a few views and functions.

 

For SQL Server 2005, you can download it from here:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

 

I downloaded the AdventureWorksDB.msi and the run the following query in the SQL 2005:

   1: exec sp_attach_db @dbname=N'AdventureWorks', 
   2: @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', 
   3: @filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'
   4:  

 

For SQL Server 2008, you can download it from this page:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=5705

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

תגובה אחת

  1. DIVY18 במרץ 2009 ב 16:55

    Hi there,

    the link to download the sample for 2005 version is broken, have reported at the site as well….

    הגב