26

I'm trying to find and create/import the Northwind database to practice my Linq-fu.

I cannot find it for the life of me, searching just turns me to this page, which in turn tells me to find it on the official page which isn't there.

http://msdn.microsoft.com/en-us/library/ms227484%28v=vs.90%29.aspx

Where can I find the Northwind database?

3 Answers3

30

Northwind doesn't come installed with SQL Server 2008. You can instead:

They come in SQL Server 2000 format / compatibility mode. Microsoft seems to have stopped using these 2 in favour of the new sample database for SQL Server 2008: AdventureWorks.

You can download AdventureWorks 2008 R2 SR1.

Microsoft has its SQL Server Product Database samples at CodePlex.

p.campbell
  • 98,673
  • 67
  • 256
  • 322
  • Wait, it seems AdventureWorks is the recommended database to use for newer versions? Is this true? –  Feb 21 '11 at 02:13
  • @Sergio: yes, that's true. That's why they haven't revved NWind and pubs, but are now favoring AdventureWorks. They're showcasing SQL Server 2008 features (including Filestream). – p.campbell Feb 22 '11 at 03:53
5

Try this for a step by step tutorial on how to find the download and install the Northwind and Pubs databases for Sql Server 2008.

northwind database sql server 2008

James Drinkard
  • 15,342
  • 16
  • 114
  • 137
John Sobolewski
  • 4,512
  • 1
  • 20
  • 26
3

For any edition of SQL SERVER. You can create the database yourself using Northwind database creation script.

Download Northwind.sql.zip from this site https://northwinddatabase.codeplex.com/downloads/get/269239

then create a database called Northwind in your Sql Server then. Unzip / decompress the file then open the sql file in Sql Server Management Studio select all code (ctrl+a) then press execute.