Where can I find the Northwind database for Microsoft SQL Server 2008?

63.9k views Asked by At

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

There are 3 answers

2
p.campbell On BEST ANSWER

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.

0
John Sobolewski On

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

1
AudioBubble On

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.